<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>wwwApp: workshop.php Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td style="padding-left: 0.5em;">
   <div id="projectname">wwwApp
   </div>
   <div id="projectbrief">A web app for workshop organizing, recruitment and qualification</div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.1.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>File&#160;Members</span></a></li>
    </ul>
  </div>
</div><!-- top -->
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">workshop.php</div>  </div>
</div><!--header-->
<div class="contents">
<a href="workshop_8php.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;&lt;?php</div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="comment">/*</span></div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="comment"> * workshop.php</span></div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;require_once(<span class="stringliteral">&#39;tasks.php&#39;</span>);</div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;</div>
<div class="line"><a name="l00010"></a><span class="lineno"><a class="code" href="workshop_8php.html#aa02cf384e084e2082688ac6f0fa9b576">   10</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#aa02cf384e084e2082688ac6f0fa9b576">addWarsztatyMenuBox</a>()</div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;{</div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;        global <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;        $PAGE-&gt;addMenuBox(<span class="stringliteral">&#39;Warsztaty&#39;</span>, <a class="code" href="utils_8php.html#ae70693a7d9a8484219fe57bdf2d2a46f">parseTable</a>(<span class="stringliteral">&#39;</span></div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="stringliteral">                ACTION              =&gt; tTitle;                     ICON;</span></div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="stringliteral">                listPublicWorkshops =&gt; workshop list;              brick.png;</span></div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="stringliteral">                listOwnWorkshops    =&gt; your workshops;             brick-green.png;</span></div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="stringliteral">                createWorkshop      =&gt; propose new workshops;      brick-add.png;</span></div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="stringliteral">        &#39;</span>));</div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;}</div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;</div>
<div class="line"><a name="l00026"></a><span class="lineno"><a class="code" href="workshop_8php.html#adbee1dd1cb134665df5762397165a698">   26</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#adbee1dd1cb134665df5762397165a698">actionListPublicWorkshops</a>()</div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;{</div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;        global <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>, $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>;</div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;listPublicWorkshops&#39;</span>))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;        $PAGE-&gt;title = _(<span class="stringliteral">&#39;Workshop list&#39;</span>);</div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a5bbc4a39c360e15b0c00714f18d2082b">assertProfileFilled</a>())  <span class="keywordflow">return</span>;</div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;</div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;        <span class="comment">// Inform how many hours of workshops did the user sign up for.</span></div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;        $DB-&gt;query(<span class="stringliteral">&#39;SELECT SUM(w.duration)</span></div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;<span class="stringliteral">                FROM table_workshops w, table_workshop_users wu</span></div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;<span class="stringliteral">                WHERE w.status=$1 AND w.edition=$2 AND wu.wid=w.wid AND wu.uid=$3&#39;</span>,</div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;                <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>(<span class="stringliteral">&#39;accepted&#39;</span>)-&gt;<span class="keywordtype">id</span>, <a class="code" href="utils_8php.html#a86acce3c002ca1af709fd1b04f2f82fa">getOption</a>(<span class="stringliteral">&#39;currentEdition&#39;</span>), $USER[<span class="stringliteral">&#39;uid&#39;</span>]);</div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;        $sum = intval($DB-&gt;fetch());</div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;        <span class="keywordflow">if</span> ($sum)</div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;        {</div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;                $msg = sprintf(<a class="code" href="user_2utils_8php.html#a7144fa5a413ad5690425b7b720aeedba">genderize</a>(_(<span class="stringliteral">&#39;You signed up for %d x 1,5 hours of workshops.&#39;</span>)), $sum);</div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;                <span class="keywordflow">if</span> ($sum&gt;30)  $msg .= <span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>. _(<span class="stringliteral">&#39;Remember that WWW has approximately 36 x 1,5 hours in total.&#39;</span>);</div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;                $PAGE-&gt;addMessage($msg, <span class="stringliteral">&#39;info&#39;</span>);</div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;        }</div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;</div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;        <span class="comment">// Public workshops = workshops with type:workshop and status:accepted.</span></div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;        <a class="code" href="workshop_8php.html#a6a380b691dafabf6af1a71981468f083">listWorkshops</a>(<span class="stringliteral">&#39;Public&#39;</span>,</div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;                <span class="stringliteral">&#39;(type=&#39;</span>.  <a class="code" href="enum_8php.html#a11cd73ec04448245e92daedfab9c2bdd">enumBlockType</a>(<span class="stringliteral">&#39;workshop&#39;</span>)-&gt;<span class="keywordtype">id</span> .<span class="stringliteral">&#39; AND &#39;</span>.</div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;                <span class="stringliteral">&#39;status=&#39;</span>. <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>(<span class="stringliteral">&#39;accepted&#39;</span>)-&gt;<span class="keywordtype">id</span> .<span class="charliteral">&#39;)&#39;</span>,</div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;                array(<span class="stringliteral">&#39;wid&#39;</span>,<span class="stringliteral">&#39;lecturers&#39;</span>,<span class="stringliteral">&#39;title&#39;</span>,<span class="stringliteral">&#39;subject&#39;</span>,<span class="stringliteral">&#39;duration&#39;</span>,<span class="stringliteral">&#39;participants&#39;</span>));</div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;}</div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;</div>
<div class="line"><a name="l00057"></a><span class="lineno"><a class="code" href="workshop_8php.html#aa0a23a469eaf27d4e25fcd9899232005">   57</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#aa0a23a469eaf27d4e25fcd9899232005">actionListOwnWorkshops</a>()</div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;{</div>
<div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;        global $USER, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;listOwnWorkshops&#39;</span>))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;        $PAGE-&gt;title = _(<span class="stringliteral">&#39;Your workshops&#39;</span>);</div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;        $where = <span class="stringliteral">&#39;EXISTS (SELECT wu.uid FROM table_workshop_users wu WHERE wu.uid=&#39;</span>. $USER[<span class="stringliteral">&#39;uid&#39;</span>].<span class="stringliteral">&#39;</span></div>
<div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;<span class="stringliteral">                AND wu.wid = w.wid AND wu.participant=&#39;</span>. <a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>(<span class="stringliteral">&#39;lecturer&#39;</span>)-&gt;id .<span class="charliteral">&#39;)&#39;</span>;</div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;        <a class="code" href="workshop_8php.html#a6a380b691dafabf6af1a71981468f083">listWorkshops</a>(<span class="stringliteral">&#39;Own&#39;</span>, $where,</div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;                array(<span class="stringliteral">&#39;wid&#39;</span>,<span class="stringliteral">&#39;lecturers&#39;</span>,<span class="stringliteral">&#39;title&#39;</span>,<span class="stringliteral">&#39;type&#39;</span>,<span class="stringliteral">&#39;subject&#39;</span>,<span class="stringliteral">&#39;duration&#39;</span>,<span class="stringliteral">&#39;status&#39;</span>,<span class="stringliteral">&#39;participants&#39;</span>));</div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;}</div>
<div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;</div>
<div class="line"><a name="l00072"></a><span class="lineno"><a class="code" href="workshop_8php.html#ac3693909fdfeb9db13ae3a9bb96f5c23">   72</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#ac3693909fdfeb9db13ae3a9bb96f5c23">actionListAllWorkshops</a>()</div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;{</div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;        global <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;listAllWorkshops&#39;</span>))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;        $PAGE-&gt;title = _(<span class="stringliteral">&#39;All workshops&#39;</span>);</div>
<div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;        <a class="code" href="workshop_8php.html#a6a380b691dafabf6af1a71981468f083">listWorkshops</a>(<span class="stringliteral">&#39;All&#39;</span>, <span class="stringliteral">&#39;&#39;</span>,</div>
<div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;                array(<span class="stringliteral">&#39;wid&#39;</span>,<span class="stringliteral">&#39;lecturers&#39;</span>,<span class="stringliteral">&#39;title&#39;</span>,<span class="stringliteral">&#39;type&#39;</span>,<span class="stringliteral">&#39;subject&#39;</span>,<span class="stringliteral">&#39;duration&#39;</span>,<span class="stringliteral">&#39;status&#39;</span>,<span class="stringliteral">&#39;participants&#39;</span>));</div>
<div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;}</div>
<div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160;</div>
<div class="line"><a name="l00088"></a><span class="lineno"><a class="code" href="workshop_8php.html#a6a380b691dafabf6af1a71981468f083">   88</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a6a380b691dafabf6af1a71981468f083">listWorkshops</a>($which, $where, $columns)</div>
<div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;{</div>
<div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;</div>
<div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;        $cols = <a class="code" href="utils_8php.html#ae70693a7d9a8484219fe57bdf2d2a46f">parseTable</a>(<span class="stringliteral">&#39;</span></div>
<div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;<span class="stringliteral">                COLUMN        =&gt; tTH;             ORDER;</span></div>
<div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;<span class="stringliteral">                wid           =&gt; #;               w.wid;</span></div>
<div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;<span class="stringliteral">                lecturers     =&gt; lecturers;       lecturers;</span></div>
<div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;<span class="stringliteral">                title         =&gt; title;           w.title;</span></div>
<div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;<span class="stringliteral">                type          =&gt; type;            w.type;</span></div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;<span class="stringliteral">                subject       =&gt; subjects;        w.subjects_order;</span></div>
<div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;<span class="stringliteral">                duration      =&gt; duration [1.5h]; w.duration DESC;</span></div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;<span class="stringliteral">                status        =&gt; status;          w.status;</span></div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;<span class="stringliteral">                participants  =&gt; signups;         count_accepted DESC;</span></div>
<div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;<span class="stringliteral">        &#39;</span>);</div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;</div>
<div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;        $from = <span class="stringliteral">&#39;&#39;</span>;</div>
<div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;        $whereClauses = array();</div>
<div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;        $orderby = array();</div>
<div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;        <span class="comment">/* ORDER BY (remember in SESSION, keep stabile, special order when ordering by lecturers) */</span></div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;        $allowed = array();</div>
<div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;        <span class="keywordflow">foreach</span> ($cols as $col)  <span class="keywordflow">if</span> ($col[<span class="stringliteral">&#39;order&#39;</span>] != <span class="stringliteral">&#39;lecturers&#39;</span>)  $allowed[]= $col[<span class="stringliteral">&#39;order&#39;</span>];</div>
<div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;        <span class="keywordflow">if</span> (!isset($_SESSION[<span class="stringliteral">&#39;workshopOrder&#39;</span>]))  $_SESSION[<span class="stringliteral">&#39;workshopOrder&#39;</span>] = array();</div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;        <span class="keywordflow">if</span> (isset($_GET[<span class="stringliteral">&#39;order&#39;</span>]) &amp;&amp; $_GET[<span class="stringliteral">&#39;order&#39;</span>] ==<span class="stringliteral">&#39;lecturers&#39;</span>)</div>
<div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;        {</div>
<div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;                $orderby[] = <span class="stringliteral">&#39;u.ordername&#39;</span>;</div>
<div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;                $from = <span class="stringliteral">&#39;, table_users u&#39;</span>;</div>
<div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;                $whereClauses[] = <span class="stringliteral">&#39;EXISTS (SELECT * FROM table_workshop_users wu</span></div>
<div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;<span class="stringliteral">                        WHERE w.wid=wu.wid AND u.uid=wu.uid</span></div>
<div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;<span class="stringliteral">                                AND participant=&#39;</span>. <a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>(<span class="stringliteral">&#39;lecturer&#39;</span>)-&gt;id .<span class="charliteral">&#39;)&#39;</span>;</div>
<div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;When sorting by lecturers, common workshops are shown repeatedly.&#39;</span>), <span class="stringliteral">&#39;info&#39;</span>);</div>
<div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;        }</div>
<div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;        <span class="keywordflow">else</span> <span class="keywordflow">if</span> (isset($_GET[<span class="stringliteral">&#39;order&#39;</span>]))</div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;                $_SESSION[<span class="stringliteral">&#39;workshopOrder&#39;</span>][]= $_GET[<span class="stringliteral">&#39;order&#39;</span>];</div>
<div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;        <span class="keywordflow">while</span> (count($_SESSION[<span class="stringliteral">&#39;workshopOrder&#39;</span>]) &gt; 3)</div>
<div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;                array_shift($_SESSION[<span class="stringliteral">&#39;workshopOrder&#39;</span>]);</div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;</div>
<div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;        $orderClauses = array_reverse($_SESSION[<span class="stringliteral">&#39;workshopOrder&#39;</span>]);</div>
<div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;        $orderClauses[]= <span class="stringliteral">&#39;w.title&#39;</span>;</div>
<div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;        <span class="keywordflow">foreach</span> ($orderClauses as $o)</div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;                <span class="keywordflow">if</span> (in_array($o, $allowed, <span class="keyword">true</span>) &amp;&amp; !in_array($o, $orderby))</div>
<div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;                        $orderby[]= $o;</div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;        $orderby = implode(<span class="charliteral">&#39;,&#39;</span>, $orderby);</div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;</div>
<div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;        <span class="comment">/* WHERE (current editions, restriction to subject) */</span></div>
<div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;        <span class="keywordflow">if</span> (!empty($where))  $whereClauses[]= $where;</div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;        $whereClauses[]= <span class="stringliteral">&#39;w.edition=&#39;</span>. intval(<a class="code" href="utils_8php.html#a86acce3c002ca1af709fd1b04f2f82fa">getOption</a>(<span class="stringliteral">&#39;currentEdition&#39;</span>));</div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;        <span class="keywordflow">if</span> (isset($_GET[<span class="stringliteral">&#39;subject&#39;</span>]) &amp;&amp; <a class="code" href="enum_8php.html#a77f5eebe56acc69d13486423d13cb83d">enumSubject</a>()-&gt;exists($_GET[<span class="stringliteral">&#39;subject&#39;</span>]))</div>
<div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;                $whereClauses[]= <span class="stringliteral">&#39;EXISTS (SELECT * FROM table_workshop_subjects ws</span></div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;<span class="stringliteral">                        WHERE ws.wid=w.wid AND ws.subject=\&#39;&#39;</span>. $_GET[<span class="stringliteral">&#39;subject&#39;</span>] .<span class="charliteral">&#39;\&#39;</span>)<span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;<span class="stringliteral">        if (!empty($whereClauses))  $where = &#39;</span>WHERE <span class="stringliteral">&#39;. implode(&#39;</span> AND <span class="stringliteral">&#39;, $whereClauses);</span></div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;<span class="stringliteral">        else $where = &#39;</span><span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;<span class="stringliteral">        /* SELECT (participant counts by status) */</span></div>
<div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;<span class="stringliteral">        $selectParticipants = &#39;</span><span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;<span class="stringliteral">        foreach (enumParticipantStatus() as $statusName =&gt; $status)</span></div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;<span class="stringliteral">                $selectParticipants .= &#39;</span>(SELECT COUNT(*) FROM table_workshop_users wu</div>
<div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;                        WHERE wu.wid=w.wid AND participant=<span class="stringliteral">&#39;. $status-&gt;id .&#39;</span>) AS count_<span class="stringliteral">&#39;. $statusName .&#39;</span>,<span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;<span class="stringliteral">        $workshops = $DB-&gt;query(&#39;</span></div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;                SELECT w.wid, w.title, w.status, w.type, w.duration, w.link,</div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;                        <span class="stringliteral">&#39;. $selectParticipants .&#39;</span></div>
<div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;                        (SELECT participant FROM table_workshop_users wu</div>
<div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;                         WHERE wu.wid=w.wid AND wu.uid=$1) AS participant</div>
<div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;                FROM table_workshops w<span class="stringliteral">&#39;. $from .&#39;</span></div>
<div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;                <span class="stringliteral">&#39;. $where .&#39;</span></div>
<div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;                ORDER BY w.edition DESC, <span class="stringliteral">&#39;. $orderby, $USER[&#39;</span>uid<span class="stringliteral">&#39;]);</span></div>
<div class="line"><a name="l00156"></a><span class="lineno">  156</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;<span class="stringliteral">        $PAGE-&gt;headerTitle = &quot;&lt;h2&gt;&lt;a href=&#39;</span>list${which}Workshops<span class="stringliteral">&#39;&gt;&quot;. $PAGE-&gt;title . &quot;&lt;/a&gt;&lt;/h2&gt;&quot;;</span></div>
<div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;<span class="stringliteral">        echo &quot;&lt;table class=&#39;</span>workshopList<span class="stringliteral">&#39;&gt;&quot;;</span></div>
<div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;<span class="stringliteral">        echo &quot;&lt;thead&gt;&lt;tr&gt;&quot;;</span></div>
<div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;<span class="stringliteral">        foreach ($columns as $c)</span></div>
<div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;<span class="stringliteral">        {</span></div>
<div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160;<span class="stringliteral">                $th = $cols[$c][&#39;</span>th<span class="stringliteral">&#39;];</span></div>
<div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;<span class="stringliteral">                $order = htmlspecialchars(urlencode($cols[$c][&#39;</span>order<span class="stringliteral">&#39;]), ENT_QUOTES);</span></div>
<div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;<span class="stringliteral">                echo &quot;&lt;th&gt;&lt;a href=&#39;</span>list${which}Workshops?order=$order<span class="stringliteral">&#39;&gt;$th&lt;/a&gt;&lt;/th&gt;&quot;;</span></div>
<div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;<span class="stringliteral">        echo &quot;&lt;/tr&gt;&lt;/thead&gt;&lt;tbody&gt;&quot;;</span></div>
<div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160;<span class="stringliteral">        foreach ($workshops as $row)</span></div>
<div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160;<span class="stringliteral">        {</span></div>
<div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;<span class="stringliteral">                $status = enumBlockStatus(intval($row[&#39;</span>status<span class="stringliteral">&#39;]));</span></div>
<div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;<span class="stringliteral">                $row[&#39;</span>status<span class="stringliteral">&#39;] = userCan(&#39;</span>seeWorkshopStatus<span class="stringliteral">&#39;) ? $status-&gt;decision : $status-&gt;status;</span></div>
<div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;<span class="stringliteral">                $row[&#39;</span>status<span class="stringliteral">&#39;] = str_replace(&#39;</span> <span class="charliteral">&#39;,&#39;</span>&amp;nbsp;<span class="stringliteral">&#39;, $row[&#39;</span>status<span class="stringliteral">&#39;]);</span></div>
<div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;<span class="stringliteral">                $row[&#39;</span>lecturers<span class="stringliteral">&#39;] = array();</span></div>
<div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;<span class="stringliteral">                foreach (getLecturers($row[&#39;</span>wid<span class="stringliteral">&#39;]) as $lecturer)</span></div>
<div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;<span class="stringliteral">                        $row[&#39;</span>lecturers<span class="stringliteral">&#39;][]= getUserBadge($lecturer);</span></div>
<div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;<span class="stringliteral">                $row[&#39;</span>lecturers<span class="stringliteral">&#39;] = implode(&#39;</span>,&lt;br/&gt;<span class="stringliteral">&#39;, $row[&#39;</span>lecturers<span class="stringliteral">&#39;]);</span></div>
<div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;<span class="stringliteral">                $row[&#39;</span>type<span class="stringliteral">&#39;] = enumBlockType(intval($row[&#39;</span>type<span class="stringliteral">&#39;]))-&gt;short;</span></div>
<div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00180"></a><span class="lineno">  180</span>&#160;<span class="stringliteral">                $subjects = $DB-&gt;query(&#39;</span></div>
<div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;                        SELECT subject FROM table_workshop_subjects</div>
<div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160;                        WHERE wid=$1 ORDER BY subject<span class="stringliteral">&#39;, $row[&#39;</span>wid<span class="stringliteral">&#39;])-&gt;fetch_column();</span></div>
<div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;<span class="stringliteral">                $row[&#39;</span>subject<span class="stringliteral">&#39;] = &#39;</span><span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;<span class="stringliteral">                foreach ($subjects as $subject)</span></div>
<div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;<span class="stringliteral">                {</span></div>
<div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;<span class="stringliteral">                        $s = enumSubject($subject);</span></div>
<div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;<span class="stringliteral">                        $row[&#39;</span>subject<span class="stringliteral">&#39;] .= getIcon(&#39;</span>subject-<span class="stringliteral">&#39;. $s-&gt;icon .&#39;</span>.png<span class="stringliteral">&#39;, $s-&gt;description,</span></div>
<div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;<span class="stringliteral">                         &quot;list${which}Workshops?subject=$subject&quot;);</span></div>
<div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;<span class="stringliteral">                }</span></div>
<div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160;<span class="stringliteral">                $row[&#39;</span>title<span class="stringliteral">&#39;] = &#39;</span>&lt;a href=<span class="stringliteral">&quot;showWorkshop(&#39;. $row[&#39;wid&#39;] .&#39;)&quot;</span>&gt;<span class="stringliteral">&#39;. $row[&#39;</span>title<span class="stringliteral">&#39;] .&#39;</span>&lt;/a&gt;<span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;<span class="stringliteral">                $row[&#39;</span>participants<span class="stringliteral">&#39;] = &#39;</span><span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160;<span class="stringliteral">                if (userCan(&#39;</span>showWorkshopParticipants<span class="stringliteral">&#39;, getLecturers($row[&#39;</span>wid<span class="stringliteral">&#39;])))</span></div>
<div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;<span class="stringliteral">                {</span></div>
<div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160;<span class="stringliteral">                        $tip = &#39;</span><span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;<span class="stringliteral">                        foreach (enumParticipantStatus() as $statusName =&gt; $status)</span></div>
<div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;<span class="stringliteral">                                $tip .= genderize($status-&gt;description, &#39;</span>p<span class="stringliteral">&#39;) .&#39;</span>: <span class="stringliteral">&#39;. $row[&quot;count_$statusName&quot;] .&#39;</span>&lt;br/&gt;<span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;<span class="stringliteral">                        $row[&#39;</span>participants<span class="stringliteral">&#39;] .= &#39;</span>&lt;a href=<span class="stringliteral">&quot;showWorkshopTasks(&#39;. $row[&#39;wid&#39;] .&#39;)&quot;</span> <span class="stringliteral">&#39;. getTipJS($tip) .&#39;</span>&gt;<span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;<span class="stringliteral">                        $row[&#39;</span>participants<span class="stringliteral">&#39;] .= ($row[&#39;</span>count_accepted<span class="stringliteral">&#39;] + $row[&#39;</span>count_autoaccepted<span class="stringliteral">&#39;]) .&#39;</span>&lt;/a&gt;<span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;<span class="stringliteral">                }</span></div>
<div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160;<span class="stringliteral">                $participant = enumParticipantStatus(intval($row[&#39;</span>participant<span class="stringliteral">&#39;]));</span></div>
<div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;<span class="stringliteral">                if (isset($participant-&gt;icon))</span></div>
<div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;<span class="stringliteral">                        $row[&#39;</span>participants<span class="stringliteral">&#39;] .= &#39;</span> <span class="stringliteral">&#39;. getIcon($participant-&gt;icon, genderize($participant-&gt;explanation));</span></div>
<div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;<span class="stringliteral">                $class = alternate(&#39;</span>even<span class="stringliteral">&#39;, &#39;</span>odd<span class="stringliteral">&#39;);</span></div>
<div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;<span class="stringliteral">                echo &quot;&lt;tr class=&#39;</span>$class<span class="stringliteral">&#39;&gt;&quot;;</span></div>
<div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;<span class="stringliteral">                foreach ($columns as $c)</span></div>
<div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;<span class="stringliteral">                        echo &#39;</span>&lt;td&gt;<span class="stringliteral">&#39;. $row[$c] .&#39;</span>&lt;/td&gt;<span class="stringliteral">&#39;;</span></div>
<div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160;<span class="stringliteral">                echo &quot;&lt;/tr&gt;&quot;;</span></div>
<div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;<span class="stringliteral">        echo &quot;&lt;/tbody&gt;&lt;/table&gt;&quot;;</span></div>
<div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;<span class="stringliteral">        if (count($workshops) == 0)</span></div>
<div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;<span class="stringliteral">                echo _(&#39;</span>No workshops have been accepted <span class="keywordflow">for</span> <span class="keyword">this</span> edition yet.<span class="stringliteral">&#39;);</span></div>
<div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;<span class="stringliteral">}</span></div>
<div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00224"></a><span class="lineno"><a class="code" href="workshop_8php.html#a02e8f38b818a3b8abd93a56b25d0ede6">  224</a></span>&#160;<span class="stringliteral">function getLecturers($wid)</span></div>
<div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160;<span class="stringliteral">{</span></div>
<div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160;<span class="stringliteral">        global $DB;</span></div>
<div class="line"><a name="l00227"></a><span class="lineno">  227</span>&#160;<span class="stringliteral">        $lecturers = $DB-&gt;query(&#39;</span>SELECT uid FROM table_workshop_users WHERE participant=$1 AND wid=$2<span class="stringliteral">&#39;,</span></div>
<div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;<span class="stringliteral">                enumParticipantStatus(&#39;</span>lecturer<span class="stringliteral">&#39;)-&gt;id, $wid);</span></div>
<div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160;<span class="stringliteral">        return $lecturers-&gt;fetch_column();</span></div>
<div class="line"><a name="l00230"></a><span class="lineno">  230</span>&#160;<span class="stringliteral">}</span></div>
<div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00237"></a><span class="lineno"><a class="code" href="workshop_8php.html#a1321a650f322d9871877a1228d324c5f">  237</a></span>&#160;<span class="stringliteral">function actionShowWorkshop($wid = null)</span></div>
<div class="line"><a name="l00238"></a><span class="lineno">  238</span>&#160;<span class="stringliteral">{</span></div>
<div class="line"><a name="l00239"></a><span class="lineno">  239</span>&#160;<span class="stringliteral">        global $USER, $DB, $PAGE;</span></div>
<div class="line"><a name="l00240"></a><span class="lineno">  240</span>&#160;<span class="stringliteral">        if (is_null($wid))  throw new KnownException(_(&#39;</span>No workshop <span class="keywordtype">id</span> given.<span class="stringliteral">&#39;), &#39;</span>400 Bad Request<span class="stringliteral">&#39;); // Handle deprecated links.</span></div>
<div class="line"><a name="l00241"></a><span class="lineno">  241</span>&#160;<span class="stringliteral">        $wid = intval($wid);</span></div>
<div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00243"></a><span class="lineno">  243</span>&#160;<span class="stringliteral">        $data = $DB-&gt;workshops[$wid]-&gt;assoc(&#39;</span>*<span class="stringliteral">&#39;);</span></div>
<div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;<span class="stringliteral">        if (!$data)  throw new KnownException(_(&#39;</span>Workshop not found.<span class="stringliteral">&#39;), &#39;</span>404 Not Found<span class="stringliteral">&#39;);</span></div>
<div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;<span class="stringliteral">        $data[&#39;</span>title<span class="stringliteral">&#39;] = htmlspecialchars($data[&#39;</span>title<span class="stringliteral">&#39;]);</span></div>
<div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;<span class="stringliteral">        $data[&#39;</span>type<span class="stringliteral">&#39;] = ucfirst(enumBlockType(intval($data[&#39;</span>type<span class="stringliteral">&#39;]))-&gt;description);</span></div>
<div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160;<span class="stringliteral">        $data[&#39;</span>description<span class="stringliteral">&#39;] = parseUserHTML($data[&#39;</span>description<span class="stringliteral">&#39;]);</span></div>
<div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00249"></a><span class="lineno">  249</span>&#160;<span class="stringliteral">        $participant = $DB-&gt;workshop_users[array(&#39;</span>wid<span class="stringliteral">&#39;=&gt;$wid, &#39;</span>uid<span class="stringliteral">&#39;=&gt;$USER[&#39;</span>uid<span class="stringliteral">&#39;])]-&gt;get(&#39;</span>participant<span class="stringliteral">&#39;);</span></div>
<div class="line"><a name="l00250"></a><span class="lineno">  250</span>&#160;<span class="stringliteral">        $participant = intval($participant);</span></div>
<div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160;<span class="stringliteral">        // Lecturers list.</span></div>
<div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;<span class="stringliteral">        $data[&#39;</span>by<span class="stringliteral">&#39;] = array();</span></div>
<div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160;<span class="stringliteral">        $lecturers = getLecturers($wid);</span></div>
<div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;<span class="stringliteral">        $displayEmail = $participant || userCan(&#39;</span>editWorkshop<span class="stringliteral">&#39;, $lecturers);</span></div>
<div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;<span class="stringliteral">        foreach ($lecturers as $lecturer)</span></div>
<div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;<span class="stringliteral">                $data[&#39;</span>by<span class="stringliteral">&#39;][]= getUserBadge($lecturer, $displayEmail);</span></div>
<div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;<span class="stringliteral">        $data[&#39;</span>by<span class="stringliteral">&#39;] =  ngettext(&#39;</span>Lecturer<span class="stringliteral">&#39;, &#39;</span>Lecturers<span class="stringliteral">&#39;, count($data[&#39;</span>by<span class="stringliteral">&#39;])) .&#39;</span>: <span class="stringliteral">&#39;. implode(&#39;</span>, <span class="stringliteral">&#39;, $data[&#39;</span>by<span class="stringliteral">&#39;]);</span></div>
<div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;<span class="stringliteral">        if (!userCan(&#39;</span>showWorkshop<span class="stringliteral">&#39;, $lecturers))  throw new PolicyException();</span></div>
<div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;<span class="stringliteral">        if (empty($data[&#39;</span>link<span class="stringliteral">&#39;]))</span></div>
<div class="line"><a name="l00263"></a><span class="lineno">  263</span>&#160;<span class="stringliteral">                $data[&#39;</span>link<span class="stringliteral">&#39;] = &#39;</span>http:<span class="comment">//warsztatywww.wikidot.com/www&#39;. getOption(&#39;currentEdition&#39;).</span></div>
<div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;                        <span class="charliteral">&#39;:&#39;</span>. urlencode($data[<span class="stringliteral">&#39;title&#39;</span>]);</div>
<div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;</div>
<div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;        <span class="comment">// The subjects.</span></div>
<div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;        $subjects = $DB-&gt;query(<span class="stringliteral">&#39;SELECT subject FROM table_workshop_subjects WHERE wid=$1&#39;</span>, $wid);</div>
<div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;        $data[<span class="stringliteral">&#39;subjects&#39;</span>] = array();</div>
<div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160;        <span class="keywordflow">foreach</span> ($subjects as $subject)</div>
<div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;                $data[<span class="stringliteral">&#39;subjects&#39;</span>][]= <a class="code" href="enum_8php.html#a77f5eebe56acc69d13486423d13cb83d">enumSubject</a>($subject[<span class="stringliteral">&#39;subject&#39;</span>])-&gt;description;</div>
<div class="line"><a name="l00271"></a><span class="lineno">  271</span>&#160;        $data[<span class="stringliteral">&#39;subjects&#39;</span>] = implode(<span class="stringliteral">&#39;, &#39;</span>, $data[<span class="stringliteral">&#39;subjects&#39;</span>]);</div>
<div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;</div>
<div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;        <span class="comment">// Basic info.</span></div>
<div class="line"><a name="l00274"></a><span class="lineno">  274</span>&#160;        $PAGE-&gt;title = $data[<span class="stringliteral">&#39;title&#39;</span>];</div>
<div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160;        $PAGE-&gt;headerTitle = <span class="stringliteral">&#39;&#39;</span>;</div>
<div class="line"><a name="l00276"></a><span class="lineno">  276</span>&#160;        $template = <span class="keyword">new</span> <a class="code" href="classSimpleTemplate.html">SimpleTemplate</a>($data);</div>
<div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;        ?&gt;</div>
<div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;                &lt;span <span class="keyword">class</span>=<span class="stringliteral">&#39;left&#39;</span>&gt;%wid%.&amp;nbsp;&lt;/span&gt;&lt;h2&gt;%title% &lt;span <span class="keyword">class</span>=<span class="stringliteral">&#39;tabs&#39;</span>&gt;</div>
<div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;                        &lt;a <span class="keyword">class</span>=<span class="stringliteral">&#39;selected&#39;</span>&gt;{{description}}&lt;/a&gt;</div>
<div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;                        &lt;a href=<span class="stringliteral">&quot;showWorkshopTasks(%wid%)&quot;</span>&gt;{{signups and tasks}}&lt;/a&gt;</div>
<div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160;                &lt;/span&gt;&lt;/h2&gt;</div>
<div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160;                %type%: %subjects%.&lt;br/&gt;</div>
<div class="line"><a name="l00283"></a><span class="lineno">  283</span>&#160;                %by%&lt;br/&gt;</div>
<div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;                {{Duration}}: %duration% × 1,5 godz.&lt;br/&gt;</div>
<div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;                &lt;a href=<span class="stringliteral">&quot;%link%&quot;</span>&gt;{{see the description on wikidot}}&lt;/a&gt;&lt;br/&gt;</div>
<div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;                &lt;br/&gt;</div>
<div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;        &lt;?php</div>
<div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;        echo $template-&gt;finish(<span class="keyword">true</span>);</div>
<div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;</div>
<div class="line"><a name="l00290"></a><span class="lineno">  290</span>&#160;        <span class="comment">// The signup/signout button (same as in showWorkshopTasks).</span></div>
<div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>($participant)-&gt;inArray(array(<span class="stringliteral">&#39;candidate&#39;</span>, <span class="stringliteral">&#39;autoaccepted&#39;</span>)))</div>
<div class="line"><a name="l00292"></a><span class="lineno">  292</span>&#160;                echo <a class="code" href="template_8php.html#a93f1d2b73c6defc9f0af8e7e17b0b47d">getButton</a>(_(<span class="stringliteral">&#39;sign out&#39;</span>), <span class="stringliteral">&quot;resignFromWorkshop($wid)&quot;</span>, <span class="stringliteral">&#39;cart-remove.png&#39;</span>)  .<span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;        <span class="keywordflow">else</span> <span class="keywordflow">if</span> (!$participant &amp;&amp; <a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;signUpForWorkshop&#39;</span>, $lecturers))</div>
<div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160;                echo <a class="code" href="template_8php.html#a93f1d2b73c6defc9f0af8e7e17b0b47d">getButton</a>(_(<span class="stringliteral">&#39;sign up&#39;</span>), <span class="stringliteral">&quot;signUpForWorkshop($wid)&quot;</span>, <span class="stringliteral">&#39;cart-put.png&#39;</span>) .<span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00295"></a><span class="lineno">  295</span>&#160;        echo <span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00296"></a><span class="lineno">  296</span>&#160;</div>
<div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;        <span class="comment">// Proposition description.</span></div>
<div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;showWorkshopDetails&#39;</span>, $lecturers)) {</div>
<div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;                echo _(<span class="stringliteral">&#39;Proposal&#39;</span>).<span class="stringliteral">&#39;: &lt;div class=&quot;descriptionBox&quot;&gt;&#39;</span>. $data[<span class="stringliteral">&#39;description&#39;</span>] .<span class="stringliteral">&#39;&lt;/div&gt;&#39;</span>;</div>
<div class="line"><a name="l00300"></a><span class="lineno">  300</span>&#160;        }</div>
<div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;        <span class="comment">// Workshop block status (e.g. accepted or not).</span></div>
<div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;changeWorkshopStatus&#39;</span>, $lecturers))</div>
<div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;        {</div>
<div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160;                echo _(<span class="stringliteral">&#39;Status:&#39;</span>);</div>
<div class="line"><a name="l00305"></a><span class="lineno">  305</span>&#160;                $inputs = <a class="code" href="utils_8php.html#ae70693a7d9a8484219fe57bdf2d2a46f">parseTable</a>(<span class="stringliteral">&#39;</span></div>
<div class="line"><a name="l00306"></a><span class="lineno">  306</span>&#160;<span class="stringliteral">                        NAME   =&gt; TYPE;   tDESCRIPTION;</span></div>
<div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;<span class="stringliteral">                        status =&gt; select; ;</span></div>
<div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160;<span class="stringliteral">                &#39;</span>);</div>
<div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;                $inputs[<span class="stringliteral">&#39;status&#39;</span>][<span class="stringliteral">&#39;options&#39;</span>] = <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>()-&gt;assoc(<span class="stringliteral">&#39;key&#39;</span>, <span class="stringliteral">&#39;decision&#39;</span>);</div>
<div class="line"><a name="l00310"></a><span class="lineno">  310</span>&#160;                $form = <span class="keyword">new</span> <a class="code" href="classForm.html">Form</a>($inputs);</div>
<div class="line"><a name="l00311"></a><span class="lineno">  311</span>&#160;                <span class="keywordflow">if</span> ($form-&gt;submitted())</div>
<div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;                {</div>
<div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;                        $values = $form-&gt;fetchAndValidateValues();</div>
<div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;                        <span class="keywordflow">if</span> ($form-&gt;valid)</div>
<div class="line"><a name="l00315"></a><span class="lineno">  315</span>&#160;                        {</div>
<div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;                                $status = <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>($values[<span class="stringliteral">&#39;status&#39;</span>])-&gt;id;</div>
<div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;                                $DB-&gt;workshops[$wid]-&gt;update(array(<span class="stringliteral">&#39;status&#39;</span> =&gt; $status));</div>
<div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;                                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;Changed workshop block status.&#39;</span>));</div>
<div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;                                <a class="code" href="log_8php.html#a5eaecfade7f5e117c98d7635b2aba95f">logUser</a>(<span class="stringliteral">&#39;workshop status chg&#39;</span>, $wid);</div>
<div class="line"><a name="l00320"></a><span class="lineno">  320</span>&#160;                        }</div>
<div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;                }</div>
<div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;                $form-&gt;values[<span class="stringliteral">&#39;status&#39;</span>] = <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>(intval($data[<span class="stringliteral">&#39;status&#39;</span>]))-&gt;key;</div>
<div class="line"><a name="l00323"></a><span class="lineno">  323</span>&#160;                echo $form-&gt;getHTML();</div>
<div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160;                echo <span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00325"></a><span class="lineno">  325</span>&#160;        }</div>
<div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160;        <span class="keywordflow">else</span> <span class="keywordflow">if</span> (<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;showWorkshopDetails&#39;</span>, $lecturers))</div>
<div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;        {</div>
<div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;                <span class="keywordflow">if</span> (<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;seeWorkshopStatus&#39;</span>))</div>
<div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;                        $status = <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>($data[<span class="stringliteral">&#39;status&#39;</span>])-&gt;decision;</div>
<div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;                <span class="keywordflow">else</span></div>
<div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160;                        $status = <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>($data[<span class="stringliteral">&#39;status&#39;</span>])-&gt;status;</div>
<div class="line"><a name="l00332"></a><span class="lineno">  332</span>&#160;                 echo _(<span class="stringliteral">&#39;Status:&#39;</span>) .<span class="stringliteral">&quot; $status&lt;br/&gt;&lt;br/&gt;&quot;</span>;</div>
<div class="line"><a name="l00333"></a><span class="lineno">  333</span>&#160;        }</div>
<div class="line"><a name="l00334"></a><span class="lineno">  334</span>&#160;        <span class="comment">// Edit-workshop button.</span></div>
<div class="line"><a name="l00335"></a><span class="lineno">  335</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;editWorkshop&#39;</span>, $lecturers))</div>
<div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;                echo <a class="code" href="template_8php.html#a93f1d2b73c6defc9f0af8e7e17b0b47d">getButton</a>(_(<span class="stringliteral">&#39;edit&#39;</span>), <span class="stringliteral">&quot;editWorkshop($wid)&quot;</span>, <span class="stringliteral">&#39;brick-edit.png&#39;</span>);</div>
<div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160;}</div>
<div class="line"><a name="l00338"></a><span class="lineno">  338</span>&#160;</div>
<div class="line"><a name="l00339"></a><span class="lineno"><a class="code" href="workshop_8php.html#a7479c454e1290d452aad78ca5d52fef9">  339</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a7479c454e1290d452aad78ca5d52fef9">actionShowWorkshopTasks</a>($wid)</div>
<div class="line"><a name="l00340"></a><span class="lineno">  340</span>&#160;{</div>
<div class="line"><a name="l00341"></a><span class="lineno">  341</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00342"></a><span class="lineno">  342</span>&#160;        $wid = intval($wid);</div>
<div class="line"><a name="l00343"></a><span class="lineno">  343</span>&#160;</div>
<div class="line"><a name="l00344"></a><span class="lineno">  344</span>&#160;        $data = $DB-&gt;workshops[$wid]-&gt;assoc(<span class="charliteral">&#39;*&#39;</span>);</div>
<div class="line"><a name="l00345"></a><span class="lineno">  345</span>&#160;        $data[<span class="stringliteral">&#39;title&#39;</span>] = htmlspecialchars($data[<span class="stringliteral">&#39;title&#39;</span>]);</div>
<div class="line"><a name="l00346"></a><span class="lineno">  346</span>&#160;        $data[<span class="stringliteral">&#39;type&#39;</span>] = ucfirst(<a class="code" href="enum_8php.html#a11cd73ec04448245e92daedfab9c2bdd">enumBlockType</a>(intval($data[<span class="stringliteral">&#39;type&#39;</span>]))-&gt;description);</div>
<div class="line"><a name="l00347"></a><span class="lineno">  347</span>&#160;        $data[<span class="stringliteral">&#39;description&#39;</span>] = <a class="code" href="template_8php.html#a4a7e99592a2690b33d53c9bcc8fd3008">parseUserHTML</a>($data[<span class="stringliteral">&#39;description&#39;</span>]);</div>
<div class="line"><a name="l00348"></a><span class="lineno">  348</span>&#160;        $lecturers = <a class="code" href="workshop_8php.html#a02e8f38b818a3b8abd93a56b25d0ede6">getLecturers</a>($wid);</div>
<div class="line"><a name="l00349"></a><span class="lineno">  349</span>&#160;        $participant = $DB-&gt;workshop_users[array(<span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid, <span class="stringliteral">&#39;uid&#39;</span>=&gt;$USER[<span class="stringliteral">&#39;uid&#39;</span>])]-&gt;get(<span class="stringliteral">&#39;participant&#39;</span>);</div>
<div class="line"><a name="l00350"></a><span class="lineno">  350</span>&#160;        $participant = intval($participant);</div>
<div class="line"><a name="l00351"></a><span class="lineno">  351</span>&#160;</div>
<div class="line"><a name="l00352"></a><span class="lineno">  352</span>&#160;        $PAGE-&gt;title = $data[<span class="stringliteral">&#39;title&#39;</span>] .<span class="stringliteral">&#39; - &#39;</span>. _(<span class="stringliteral">&#39;signups and tasks&#39;</span>);</div>
<div class="line"><a name="l00353"></a><span class="lineno">  353</span>&#160;        $PAGE-&gt;headerTitle = <span class="stringliteral">&#39;&#39;</span>;</div>
<div class="line"><a name="l00354"></a><span class="lineno">  354</span>&#160;        $template = <span class="keyword">new</span> <a class="code" href="classSimpleTemplate.html">SimpleTemplate</a>($data);</div>
<div class="line"><a name="l00355"></a><span class="lineno">  355</span>&#160;        ?&gt;</div>
<div class="line"><a name="l00356"></a><span class="lineno">  356</span>&#160;                &lt;span <span class="keyword">class</span>=<span class="stringliteral">&#39;left&#39;</span>&gt;%wid%.&amp;nbsp;&lt;/span&gt;&lt;h2&gt;%title% &lt;span <span class="keyword">class</span>=<span class="stringliteral">&#39;tabs&#39;</span>&gt;</div>
<div class="line"><a name="l00357"></a><span class="lineno">  357</span>&#160;                        &lt;a href=<span class="stringliteral">&#39;showWorkshop(%wid%)&#39;</span>&gt;{{description}}&lt;/a&gt;</div>
<div class="line"><a name="l00358"></a><span class="lineno">  358</span>&#160;                        &lt;a <span class="keyword">class</span>=<span class="stringliteral">&#39;selected&#39;</span>&gt;{{signups and tasks}}&lt;/a&gt;</div>
<div class="line"><a name="l00359"></a><span class="lineno">  359</span>&#160;                &lt;/span&gt;&lt;/h2&gt;</div>
<div class="line"><a name="l00360"></a><span class="lineno">  360</span>&#160;        &lt;?php</div>
<div class="line"><a name="l00361"></a><span class="lineno">  361</span>&#160;        echo $template-&gt;finish(<span class="keyword">true</span>);</div>
<div class="line"><a name="l00362"></a><span class="lineno">  362</span>&#160;</div>
<div class="line"><a name="l00363"></a><span class="lineno">  363</span>&#160;        echo _(<span class="stringliteral">&#39;Your status:&#39;</span>) .<span class="stringliteral">&#39; &lt;i&gt;&#39;</span>. <a class="code" href="user_2utils_8php.html#a7144fa5a413ad5690425b7b720aeedba">genderize</a>(<a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>($participant)-&gt;explanation) .<span class="stringliteral">&#39;&lt;/i&gt;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00364"></a><span class="lineno">  364</span>&#160;</div>
<div class="line"><a name="l00365"></a><span class="lineno">  365</span>&#160;        <span class="comment">// The signup/signout button (same as in showWorkshop).</span></div>
<div class="line"><a name="l00366"></a><span class="lineno">  366</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>($participant)-&gt;inArray(array(<span class="stringliteral">&#39;candidate&#39;</span>, <span class="stringliteral">&#39;autoaccepted&#39;</span>)))</div>
<div class="line"><a name="l00367"></a><span class="lineno">  367</span>&#160;                echo <a class="code" href="template_8php.html#a93f1d2b73c6defc9f0af8e7e17b0b47d">getButton</a>(_(<span class="stringliteral">&#39;sign out&#39;</span>), <span class="stringliteral">&quot;resignFromWorkshop($wid)&quot;</span>, <span class="stringliteral">&#39;cart-remove.png&#39;</span>)  .<span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00368"></a><span class="lineno">  368</span>&#160;        <span class="keywordflow">else</span> <span class="keywordflow">if</span> (!$participant &amp;&amp; <a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;signUpForWorkshop&#39;</span>, $lecturers))</div>
<div class="line"><a name="l00369"></a><span class="lineno">  369</span>&#160;                echo <a class="code" href="template_8php.html#a93f1d2b73c6defc9f0af8e7e17b0b47d">getButton</a>(_(<span class="stringliteral">&#39;sign up&#39;</span>), <span class="stringliteral">&quot;signUpForWorkshop($wid)&quot;</span>, <span class="stringliteral">&#39;cart-put.png&#39;</span>) .<span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00370"></a><span class="lineno">  370</span>&#160;        echo <span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00371"></a><span class="lineno">  371</span>&#160;</div>
<div class="line"><a name="l00372"></a><span class="lineno">  372</span>&#160;        <span class="comment">// List of signed-up participants.</span></div>
<div class="line"><a name="l00373"></a><span class="lineno">  373</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;showWorkshopParticipants&#39;</span>, $lecturers))</div>
<div class="line"><a name="l00374"></a><span class="lineno">  374</span>&#160;                echo <a class="code" href="tasks_8php.html#ae1f5d73a5ddf78d15aa18706f9786b14">buildParticipantList</a>($wid) . <span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>;</div>
<div class="line"><a name="l00375"></a><span class="lineno">  375</span>&#160;</div>
<div class="line"><a name="l00376"></a><span class="lineno">  376</span>&#160;        <span class="comment">// List of qualification tasks.</span></div>
<div class="line"><a name="l00377"></a><span class="lineno">  377</span>&#160;        echo <a class="code" href="tasks_8php.html#a5330df836d593c05befda9913a6acc23">buildTaskList</a>($wid);</div>
<div class="line"><a name="l00378"></a><span class="lineno">  378</span>&#160;}</div>
<div class="line"><a name="l00379"></a><span class="lineno">  379</span>&#160;</div>
<div class="line"><a name="l00380"></a><span class="lineno"><a class="code" href="workshop_8php.html#a63ff3f7f5188439e639edd7021f90e70">  380</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a63ff3f7f5188439e639edd7021f90e70">actionCreateWorkshop</a>()</div>
<div class="line"><a name="l00381"></a><span class="lineno">  381</span>&#160;{</div>
<div class="line"><a name="l00382"></a><span class="lineno">  382</span>&#160;        <a class="code" href="workshop_8php.html#a086c665030f2f28ca42fe178f9832b0f">actionEditWorkshop</a>(-1);</div>
<div class="line"><a name="l00383"></a><span class="lineno">  383</span>&#160;}</div>
<div class="line"><a name="l00384"></a><span class="lineno">  384</span>&#160;</div>
<div class="line"><a name="l00385"></a><span class="lineno"><a class="code" href="workshop_8php.html#a086c665030f2f28ca42fe178f9832b0f">  385</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a086c665030f2f28ca42fe178f9832b0f">actionEditWorkshop</a>($wid)</div>
<div class="line"><a name="l00386"></a><span class="lineno">  386</span>&#160;{</div>
<div class="line"><a name="l00387"></a><span class="lineno">  387</span>&#160;        global $USER, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>;</div>
<div class="line"><a name="l00388"></a><span class="lineno">  388</span>&#160;        $wid = intval($wid);</div>
<div class="line"><a name="l00389"></a><span class="lineno">  389</span>&#160;        $new = ($wid == -1);</div>
<div class="line"><a name="l00390"></a><span class="lineno">  390</span>&#160;        <span class="keywordflow">if</span> ($new &amp;&amp; !<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;createWorkshop&#39;</span>))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00391"></a><span class="lineno">  391</span>&#160;        <span class="keywordflow">else</span> <span class="keywordflow">if</span> (!$new &amp;&amp; !<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;editWorkshop&#39;</span>, <a class="code" href="workshop_8php.html#a02e8f38b818a3b8abd93a56b25d0ede6">getLecturers</a>($wid)))  <span class="keywordflow">throw</span> <span class="keyword">new</span>  <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00392"></a><span class="lineno">  392</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a5bbc4a39c360e15b0c00714f18d2082b">assertProfileFilled</a>())  <span class="keywordflow">return</span>;</div>
<div class="line"><a name="l00393"></a><span class="lineno">  393</span>&#160;</div>
<div class="line"><a name="l00394"></a><span class="lineno">  394</span>&#160;        $inputs = <a class="code" href="utils_8php.html#ae70693a7d9a8484219fe57bdf2d2a46f">parseTable</a>(<span class="stringliteral">&#39;</span></div>
<div class="line"><a name="l00395"></a><span class="lineno">  395</span>&#160;<span class="stringliteral">                NAME        =&gt; TYPE;          tDESCRIPTION;                   VALIDATION;</span></div>
<div class="line"><a name="l00396"></a><span class="lineno">  396</span>&#160;<span class="stringliteral">                title       =&gt; text;          Title;                          length(5 100);</span></div>
<div class="line"><a name="l00397"></a><span class="lineno">  397</span>&#160;<span class="stringliteral">                lecturers   =&gt; readonly;      Lecturers;</span></div>
<div class="line"><a name="l00398"></a><span class="lineno">  398</span>&#160;<span class="stringliteral">                description =&gt; richtextarea;  Description;</span></div>
<div class="line"><a name="l00399"></a><span class="lineno">  399</span>&#160;<span class="stringliteral">                subjects    =&gt; checkboxgroup; Subject;</span></div>
<div class="line"><a name="l00400"></a><span class="lineno">  400</span>&#160;<span class="stringliteral">                type        =&gt; select;        Type;</span></div>
<div class="line"><a name="l00401"></a><span class="lineno">  401</span>&#160;<span class="stringliteral">                duration    =&gt; select;        Duration;                       int;             other;</span></div>
<div class="line"><a name="l00402"></a><span class="lineno">  402</span>&#160;<span class="stringliteral">                link        =&gt; text;          Link to description on wikidot;</span></div>
<div class="line"><a name="l00403"></a><span class="lineno">  403</span>&#160;<span class="stringliteral">        &#39;</span>);</div>
<div class="line"><a name="l00404"></a><span class="lineno">  404</span>&#160;</div>
<div class="line"><a name="l00405"></a><span class="lineno">  405</span>&#160;        <span class="keywordflow">if</span> (!$new)</div>
<div class="line"><a name="l00406"></a><span class="lineno">  406</span>&#160;                $inputs[<span class="stringliteral">&#39;lecturers&#39;</span>][<span class="stringliteral">&#39;description&#39;</span>] .= <span class="stringliteral">&quot; &lt;a href=&#39;editWorkshopLecturers($wid)&#39;&gt;[&quot;</span>. _(<span class="stringliteral">&#39;change&#39;</span>) .<span class="stringliteral">&quot;]&lt;/a&gt;&quot;</span>;</div>
<div class="line"><a name="l00407"></a><span class="lineno">  407</span>&#160;</div>
<div class="line"><a name="l00408"></a><span class="lineno">  408</span>&#160;        $inputs[<span class="stringliteral">&#39;description&#39;</span>][<span class="stringliteral">&#39;description&#39;</span>] .= <span class="stringliteral">&#39;&lt;br/&gt;&lt;small&gt;&#39;</span>.</div>
<div class="line"><a name="l00409"></a><span class="lineno">  409</span>&#160;                _(<span class="stringliteral">&#39;Topics addressed, difficulty, scope of material, &#39;</span>.</div>
<div class="line"><a name="l00410"></a><span class="lineno">  410</span>&#160;                  <span class="stringliteral">&#39;what will you do (theoretical problems, coding, experiments, ...). &#39;</span>.</div>
<div class="line"><a name="l00411"></a><span class="lineno">  411</span>&#160;                  <span class="stringliteral">&#39;We encourage possibly detailed descriptions.&#39;</span>)</div>
<div class="line"><a name="l00412"></a><span class="lineno">  412</span>&#160;                .<span class="stringliteral">&#39;&lt;/small&gt;&#39;</span>;</div>
<div class="line"><a name="l00413"></a><span class="lineno">  413</span>&#160;</div>
<div class="line"><a name="l00414"></a><span class="lineno">  414</span>&#160;        $inputs[<span class="stringliteral">&#39;subjects&#39;</span>][<span class="stringliteral">&#39;options&#39;</span>] = <a class="code" href="enum_8php.html#a77f5eebe56acc69d13486423d13cb83d">enumSubject</a>()-&gt;assoc(<span class="stringliteral">&#39;key&#39;</span>, <span class="stringliteral">&#39;description&#39;</span>);</div>
<div class="line"><a name="l00415"></a><span class="lineno">  415</span>&#160;        $inputs[<span class="stringliteral">&#39;type&#39;</span>][<span class="stringliteral">&#39;options&#39;</span>] = <a class="code" href="enum_8php.html#a11cd73ec04448245e92daedfab9c2bdd">enumBlockType</a>()-&gt;assoc(<span class="stringliteral">&#39;key&#39;</span>,<span class="stringliteral">&#39;description&#39;</span>);</div>
<div class="line"><a name="l00416"></a><span class="lineno">  416</span>&#160;</div>
<div class="line"><a name="l00417"></a><span class="lineno">  417</span>&#160;        $inputs[<span class="stringliteral">&#39;type&#39;</span>][<span class="stringliteral">&#39;properties&#39;</span>] = <span class="stringliteral">&#39;onchange=&quot;$(\&#39;#row_duration\&#39;).toggle(this.selectedIndex==&#39;</span>. <a class="code" href="enum_8php.html#a11cd73ec04448245e92daedfab9c2bdd">enumBlockType</a>(<span class="stringliteral">&#39;workshop&#39;</span>)-&gt;id .<span class="stringliteral">&#39;);&quot;&#39;</span>;</div>
<div class="line"><a name="l00418"></a><span class="lineno">  418</span>&#160;        $inputs[<span class="stringliteral">&#39;duration&#39;</span>][<span class="stringliteral">&#39;options&#39;</span>] = array(4=&gt;<span class="stringliteral">&#39;6h (4x1.5h)&#39;</span>, 6=&gt;<span class="stringliteral">&#39;9h (6x1.5h)&#39;</span>);</div>
<div class="line"><a name="l00419"></a><span class="lineno">  419</span>&#160;        $inputs[<span class="stringliteral">&#39;duration&#39;</span>][<span class="stringliteral">&#39;other&#39;</span>] = <span class="stringliteral">&#39;[x1,5h]&lt;span class=&quot;left&quot;&gt;(&#39;</span>.</div>
<div class="line"><a name="l00420"></a><span class="lineno">  420</span>&#160;                _(<span class="stringliteral">&#39;non-standard durations should be&lt;br/&gt; consulted with the organizers.&#39;</span>)</div>
<div class="line"><a name="l00421"></a><span class="lineno">  421</span>&#160;                 .<span class="stringliteral">&#39;)&lt;/span&gt;&#39;</span>;</div>
<div class="line"><a name="l00422"></a><span class="lineno">  422</span>&#160;</div>
<div class="line"><a name="l00423"></a><span class="lineno">  423</span>&#160;        <span class="comment">/* It seems more annoying than useful.</span></div>
<div class="line"><a name="l00424"></a><span class="lineno">  424</span>&#160;<span class="comment">        $inputs[&#39;title&#39;][&#39;properties&#39;] = &#39;onchange=&quot;$(\&#39;#link\&#39;)[0].value = \&#39;&#39;.</span></div>
<div class="line"><a name="l00425"></a><span class="lineno">  425</span>&#160;<span class="comment">        &#39;http://warsztatywww.wikidot.com/www9:&#39;.</span></div>
<div class="line"><a name="l00426"></a><span class="lineno">  426</span>&#160;<span class="comment">        &#39;\&#39; +this.value.replace(/[^a-zA-Z0-9]/g,\&#39;_\&#39;);&quot;&#39;;</span></div>
<div class="line"><a name="l00427"></a><span class="lineno">  427</span>&#160;<span class="comment">        */</span></div>
<div class="line"><a name="l00428"></a><span class="lineno">  428</span>&#160;</div>
<div class="line"><a name="l00429"></a><span class="lineno">  429</span>&#160;</div>
<div class="line"><a name="l00430"></a><span class="lineno">  430</span>&#160;        $PAGE-&gt;title = $new ? _(<span class="stringliteral">&#39;Propose a new workshop block&#39;</span>) : _(<span class="stringliteral">&#39;Edit a workshop block&#39;</span>);</div>
<div class="line"><a name="l00431"></a><span class="lineno">  431</span>&#160;        <span class="keywordflow">if</span> (!$new)</div>
<div class="line"><a name="l00432"></a><span class="lineno">  432</span>&#160;                echo <span class="stringliteral">&quot;&lt;a class=&#39;back&#39; href=&#39;showWorkshop($wid)&#39;&gt;&quot;</span>. _(<span class="stringliteral">&#39;view&#39;</span>) .<span class="stringliteral">&quot;&lt;/a&gt;&quot;</span>;</div>
<div class="line"><a name="l00433"></a><span class="lineno">  433</span>&#160;        $form = <span class="keyword">new</span> <a class="code" href="classForm.html">Form</a>($inputs);</div>
<div class="line"><a name="l00434"></a><span class="lineno">  434</span>&#160;</div>
<div class="line"><a name="l00435"></a><span class="lineno">  435</span>&#160;        <span class="keywordflow">if</span> ($form-&gt;submitted())</div>
<div class="line"><a name="l00436"></a><span class="lineno">  436</span>&#160;        {</div>
<div class="line"><a name="l00437"></a><span class="lineno">  437</span>&#160;                $values = $form-&gt;fetchAndValidateValues();</div>
<div class="line"><a name="l00438"></a><span class="lineno">  438</span>&#160;                <span class="keywordflow">if</span> ($form-&gt;valid)</div>
<div class="line"><a name="l00439"></a><span class="lineno">  439</span>&#160;                {</div>
<div class="line"><a name="l00440"></a><span class="lineno">  440</span>&#160;                        <a class="code" href="workshop_8php.html#a69d3f43278fad0780fdea41c467faccd">submitEditWorkshopForm</a>($wid, $values);</div>
<div class="line"><a name="l00441"></a><span class="lineno">  441</span>&#160;                        $new = <span class="keyword">false</span>;</div>
<div class="line"><a name="l00442"></a><span class="lineno">  442</span>&#160;                }</div>
<div class="line"><a name="l00443"></a><span class="lineno">  443</span>&#160;        }</div>
<div class="line"><a name="l00444"></a><span class="lineno">  444</span>&#160;</div>
<div class="line"><a name="l00445"></a><span class="lineno">  445</span>&#160;        <span class="keywordflow">if</span> ($new)</div>
<div class="line"><a name="l00446"></a><span class="lineno">  446</span>&#160;        {</div>
<div class="line"><a name="l00447"></a><span class="lineno">  447</span>&#160;                <span class="keywordflow">if</span> (time() &gt; $DB-&gt;editions[<a class="code" href="utils_8php.html#a86acce3c002ca1af709fd1b04f2f82fa">getOption</a>(<span class="stringliteral">&#39;currentEdition&#39;</span>)]-&gt;<span class="keyword">get</span>(<span class="stringliteral">&#39;proposaldeadline&#39;</span>))</div>
<div class="line"><a name="l00448"></a><span class="lineno">  448</span>&#160;                        $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;The deadline for workshop proposal submissions has expired. &#39;</span>.</div>
<div class="line"><a name="l00449"></a><span class="lineno">  449</span>&#160;                                <span class="stringliteral">&#39;Fill the form at your own risk.&#39;</span>), <span class="stringliteral">&#39;warning&#39;</span>);</div>
<div class="line"><a name="l00450"></a><span class="lineno">  450</span>&#160;</div>
<div class="line"><a name="l00451"></a><span class="lineno">  451</span>&#160;                $data = array(</div>
<div class="line"><a name="l00452"></a><span class="lineno">  452</span>&#160;                        <span class="stringliteral">&#39;wid&#39;</span> =&gt; -1,</div>
<div class="line"><a name="l00453"></a><span class="lineno">  453</span>&#160;                        <span class="stringliteral">&#39;title&#39;</span> =&gt; <span class="stringliteral">&#39;&#39;</span>,</div>
<div class="line"><a name="l00454"></a><span class="lineno">  454</span>&#160;                        <span class="stringliteral">&#39;description&#39;</span> =&gt; <span class="stringliteral">&#39;&#39;</span>,</div>
<div class="line"><a name="l00455"></a><span class="lineno">  455</span>&#160;                        <span class="stringliteral">&#39;status&#39;</span> =&gt; <span class="stringliteral">&#39;new&#39;</span>,</div>
<div class="line"><a name="l00456"></a><span class="lineno">  456</span>&#160;                        <span class="stringliteral">&#39;materials&#39;</span> =&gt; <span class="stringliteral">&#39;&#39;</span>,</div>
<div class="line"><a name="l00457"></a><span class="lineno">  457</span>&#160;                        <span class="stringliteral">&#39;subjects&#39;</span> =&gt; array(),</div>
<div class="line"><a name="l00458"></a><span class="lineno">  458</span>&#160;                        <span class="stringliteral">&#39;type&#39;</span> =&gt; <span class="stringliteral">&#39;workshop&#39;</span>,</div>
<div class="line"><a name="l00459"></a><span class="lineno">  459</span>&#160;                        <span class="stringliteral">&#39;duration&#39;</span> =&gt; 3*2, <span class="comment">//3*2*90min = 9h</span></div>
<div class="line"><a name="l00460"></a><span class="lineno">  460</span>&#160;                        <span class="stringliteral">&#39;duration_min&#39;</span> =&gt; 90,</div>
<div class="line"><a name="l00461"></a><span class="lineno">  461</span>&#160;                        <span class="stringliteral">&#39;link&#39;</span> =&gt; <span class="stringliteral">&#39;http://warsztatywww.wikidot.com/www&#39;</span>. <a class="code" href="utils_8php.html#a86acce3c002ca1af709fd1b04f2f82fa">getOption</a>(<span class="stringliteral">&#39;currentEdition&#39;</span>) .<span class="stringliteral">&#39;:tytul-warsztatow&#39;</span></div>
<div class="line"><a name="l00462"></a><span class="lineno">  462</span>&#160;                );</div>
<div class="line"><a name="l00463"></a><span class="lineno">  463</span>&#160;                $lecturers = array($USER[<span class="stringliteral">&#39;uid&#39;</span>]);</div>
<div class="line"><a name="l00464"></a><span class="lineno">  464</span>&#160;        }</div>
<div class="line"><a name="l00465"></a><span class="lineno">  465</span>&#160;        <span class="keywordflow">else</span></div>
<div class="line"><a name="l00466"></a><span class="lineno">  466</span>&#160;        {</div>
<div class="line"><a name="l00467"></a><span class="lineno">  467</span>&#160;                $data = $DB-&gt;workshops[$wid]-&gt;assoc(<span class="charliteral">&#39;*&#39;</span>);</div>
<div class="line"><a name="l00468"></a><span class="lineno">  468</span>&#160;                $lecturers = <a class="code" href="workshop_8php.html#a02e8f38b818a3b8abd93a56b25d0ede6">getLecturers</a>($wid);</div>
<div class="line"><a name="l00469"></a><span class="lineno">  469</span>&#160;                $data[<span class="stringliteral">&#39;type&#39;</span>] = <a class="code" href="enum_8php.html#a11cd73ec04448245e92daedfab9c2bdd">enumBlockType</a>(intval($data[<span class="stringliteral">&#39;type&#39;</span>]))-&gt;key;</div>
<div class="line"><a name="l00470"></a><span class="lineno">  470</span>&#160;                $DB-&gt;query(<span class="stringliteral">&#39;SELECT subject FROM table_workshop_subjects WHERE wid=$1&#39;</span>, $wid);</div>
<div class="line"><a name="l00471"></a><span class="lineno">  471</span>&#160;                $data[<span class="stringliteral">&#39;subjects&#39;</span>] = $DB-&gt;fetch_column();</div>
<div class="line"><a name="l00472"></a><span class="lineno">  472</span>&#160;        }</div>
<div class="line"><a name="l00473"></a><span class="lineno">  473</span>&#160;</div>
<div class="line"><a name="l00474"></a><span class="lineno">  474</span>&#160;        <span class="keywordflow">foreach</span> ($lecturers as $lecturer)</div>
<div class="line"><a name="l00475"></a><span class="lineno">  475</span>&#160;                $data[<span class="stringliteral">&#39;lecturers&#39;</span>][]= <a class="code" href="user_2utils_8php.html#a29f037f468ee2716970ae6e7293644e2">getUserBadge</a>($lecturer, <span class="keyword">true</span>);</div>
<div class="line"><a name="l00476"></a><span class="lineno">  476</span>&#160;        $data[<span class="stringliteral">&#39;lecturers&#39;</span>] =  implode(<span class="stringliteral">&#39;, &#39;</span>, $data[<span class="stringliteral">&#39;lecturers&#39;</span>]);</div>
<div class="line"><a name="l00477"></a><span class="lineno">  477</span>&#160;        <span class="keywordflow">if</span> ($new)</div>
<div class="line"><a name="l00478"></a><span class="lineno">  478</span>&#160;                $data[<span class="stringliteral">&#39;lecturers&#39;</span>] .= <span class="stringliteral">&#39; &lt;small class=&quot;right&quot;&gt;&#39;</span>.</div>
<div class="line"><a name="l00479"></a><span class="lineno">  479</span>&#160;                        _(<span class="stringliteral">&#39;You\&#39;ll be able to add more lecturers later, by editing this workshop block.&#39;</span>).</div>
<div class="line"><a name="l00480"></a><span class="lineno">  480</span>&#160;                        <span class="stringliteral">&#39;&lt;/small&gt;&#39;</span>;</div>
<div class="line"><a name="l00481"></a><span class="lineno">  481</span>&#160;</div>
<div class="line"><a name="l00482"></a><span class="lineno">  482</span>&#160;        $form-&gt;values = $data;</div>
<div class="line"><a name="l00483"></a><span class="lineno">  483</span>&#160;        echo $form-&gt;getHTML();</div>
<div class="line"><a name="l00484"></a><span class="lineno">  484</span>&#160;</div>
<div class="line"><a name="l00485"></a><span class="lineno">  485</span>&#160;        <span class="keywordflow">if</span> ($data[<span class="stringliteral">&#39;type&#39;</span>] != <span class="stringliteral">&#39;workshop&#39;</span>)</div>
<div class="line"><a name="l00486"></a><span class="lineno">  486</span>&#160;        {</div>
<div class="line"><a name="l00487"></a><span class="lineno">  487</span>&#160;                $PAGE-&gt;jsOnLoad .= <span class="stringliteral">&#39;$(&quot;#row_duration&quot;).hide();&#39;</span>;</div>
<div class="line"><a name="l00488"></a><span class="lineno">  488</span>&#160;                $PAGE-&gt;jsOnLoad .= <span class="stringliteral">&#39;$(&quot;#row_duration_other&quot;).hide();&#39;</span>;</div>
<div class="line"><a name="l00489"></a><span class="lineno">  489</span>&#160;        }</div>
<div class="line"><a name="l00490"></a><span class="lineno">  490</span>&#160;        <span class="keywordflow">if</span> (in_array($data[<span class="stringliteral">&#39;duration&#39;</span>], array_keys($inputs[<span class="stringliteral">&#39;duration&#39;</span>][<span class="stringliteral">&#39;options&#39;</span>])))</div>
<div class="line"><a name="l00491"></a><span class="lineno">  491</span>&#160;                $PAGE-&gt;jsOnLoad .= <span class="stringliteral">&#39;$(&quot;#row_duration_other&quot;).hide();&#39;</span>;</div>
<div class="line"><a name="l00492"></a><span class="lineno">  492</span>&#160;}</div>
<div class="line"><a name="l00493"></a><span class="lineno">  493</span>&#160;</div>
<div class="line"><a name="l00494"></a><span class="lineno">  494</span>&#160;</div>
<div class="line"><a name="l00495"></a><span class="lineno"><a class="code" href="workshop_8php.html#a69d3f43278fad0780fdea41c467faccd">  495</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a69d3f43278fad0780fdea41c467faccd">submitEditWorkshopForm</a>(&amp;$wid, $values)</div>
<div class="line"><a name="l00496"></a><span class="lineno">  496</span>&#160;{</div>
<div class="line"><a name="l00497"></a><span class="lineno">  497</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00498"></a><span class="lineno">  498</span>&#160;        $new = ($wid==-1);</div>
<div class="line"><a name="l00499"></a><span class="lineno">  499</span>&#160;</div>
<div class="line"><a name="l00500"></a><span class="lineno">  500</span>&#160;        $data = array(</div>
<div class="line"><a name="l00501"></a><span class="lineno">  501</span>&#160;                <span class="stringliteral">&#39;title&#39;</span> =&gt; $values[<span class="stringliteral">&#39;title&#39;</span>],</div>
<div class="line"><a name="l00502"></a><span class="lineno">  502</span>&#160;                <span class="stringliteral">&#39;description&#39;</span> =&gt; $values[<span class="stringliteral">&#39;description&#39;</span>],</div>
<div class="line"><a name="l00503"></a><span class="lineno">  503</span>&#160;                <span class="stringliteral">&#39;type&#39;</span> =&gt; <a class="code" href="enum_8php.html#a11cd73ec04448245e92daedfab9c2bdd">enumBlockType</a>($values[<span class="stringliteral">&#39;type&#39;</span>])-&gt;<span class="keywordtype">id</span>,</div>
<div class="line"><a name="l00504"></a><span class="lineno">  504</span>&#160;                <span class="stringliteral">&#39;duration&#39;</span> =&gt; ($values[<span class="stringliteral">&#39;type&#39;</span>] == <span class="stringliteral">&#39;lightLecture&#39;</span>) ? 1 : intval($values[<span class="stringliteral">&#39;duration&#39;</span>]),</div>
<div class="line"><a name="l00505"></a><span class="lineno">  505</span>&#160;                <span class="stringliteral">&#39;link&#39;</span> =&gt; trim($values[<span class="stringliteral">&#39;link&#39;</span>]),</div>
<div class="line"><a name="l00506"></a><span class="lineno">  506</span>&#160;                <span class="stringliteral">&#39;subjects_order&#39;</span> =&gt; empty($_POST[<span class="stringliteral">&#39;subjects&#39;</span>]) ? 0 : <a class="code" href="workshop_8php.html#ae8c3b8a730d8fb94ef2ca3af1e8582a4">subjectOrder</a>($_POST[<span class="stringliteral">&#39;subjects&#39;</span>])</div>
<div class="line"><a name="l00507"></a><span class="lineno">  507</span>&#160;        );</div>
<div class="line"><a name="l00508"></a><span class="lineno">  508</span>&#160;</div>
<div class="line"><a name="l00509"></a><span class="lineno">  509</span>&#160;        <span class="keywordflow">if</span> (empty($data[<span class="stringliteral">&#39;link&#39;</span>]))  $data[<span class="stringliteral">&#39;link&#39;</span>] = null;</div>
<div class="line"><a name="l00510"></a><span class="lineno">  510</span>&#160;        <span class="keywordflow">else</span> <span class="keywordflow">if</span> (strpos($data[<span class="stringliteral">&#39;link&#39;</span>], <span class="stringliteral">&#39;http://&#39;</span>) !== 0  &amp;&amp;  strpos($data[<span class="stringliteral">&#39;link&#39;</span>], <span class="stringliteral">&#39;https://&#39;</span>) !== 0)</div>
<div class="line"><a name="l00511"></a><span class="lineno">  511</span>&#160;                $data[<span class="stringliteral">&#39;link&#39;</span>] = <span class="stringliteral">&#39;http://&#39;</span>. $data[<span class="stringliteral">&#39;link&#39;</span>];</div>
<div class="line"><a name="l00512"></a><span class="lineno">  512</span>&#160;</div>
<div class="line"><a name="l00513"></a><span class="lineno">  513</span>&#160;        <span class="keywordflow">if</span> ($new)</div>
<div class="line"><a name="l00514"></a><span class="lineno">  514</span>&#160;        {</div>
<div class="line"><a name="l00515"></a><span class="lineno">  515</span>&#160;                $data = $data + array(</div>
<div class="line"><a name="l00516"></a><span class="lineno">  516</span>&#160;                        <span class="stringliteral">&#39;edition&#39;</span> =&gt; intval(<a class="code" href="utils_8php.html#a86acce3c002ca1af709fd1b04f2f82fa">getOption</a>(<span class="stringliteral">&#39;currentEdition&#39;</span>)),</div>
<div class="line"><a name="l00517"></a><span class="lineno">  517</span>&#160;                        <span class="stringliteral">&#39;status&#39;</span> =&gt; <a class="code" href="enum_8php.html#a5fba087a3870146b12b7b12c9bfc7d11">enumBlockStatus</a>(<span class="stringliteral">&#39;new&#39;</span>)-&gt;<span class="keywordtype">id</span></div>
<div class="line"><a name="l00518"></a><span class="lineno">  518</span>&#160;                );</div>
<div class="line"><a name="l00519"></a><span class="lineno">  519</span>&#160;                $DB-&gt;workshops[] = $data;</div>
<div class="line"><a name="l00520"></a><span class="lineno">  520</span>&#160;                $wid = $DB-&gt;workshops-&gt;lastValue();</div>
<div class="line"><a name="l00521"></a><span class="lineno">  521</span>&#160;                $DB-&gt;workshop_users[]= array(<span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid, <span class="stringliteral">&#39;uid&#39;</span>=&gt;$USER[<span class="stringliteral">&#39;uid&#39;</span>],</div>
<div class="line"><a name="l00522"></a><span class="lineno">  522</span>&#160;                        <span class="stringliteral">&#39;participant&#39;</span>=&gt;<a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>(<span class="stringliteral">&#39;lecturer&#39;</span>)-&gt;<span class="keywordtype">id</span>);</div>
<div class="line"><a name="l00523"></a><span class="lineno">  523</span>&#160;                <span class="keywordflow">if</span> (!empty($_POST[<span class="stringliteral">&#39;subjects&#39;</span>]))</div>
<div class="line"><a name="l00524"></a><span class="lineno">  524</span>&#160;                        <span class="keywordflow">foreach</span> ($_POST[<span class="stringliteral">&#39;subjects&#39;</span>] as $d)</div>
<div class="line"><a name="l00525"></a><span class="lineno">  525</span>&#160;                                $DB-&gt;workshop_subjects[]= array(<span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid, <span class="stringliteral">&#39;subject&#39;</span>=&gt;$d);</div>
<div class="line"><a name="l00526"></a><span class="lineno">  526</span>&#160;                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;Your proposal has been submitted.&#39;</span>), <span class="stringliteral">&#39;success&#39;</span>);</div>
<div class="line"><a name="l00527"></a><span class="lineno">  527</span>&#160;                <a class="code" href="log_8php.html#a5eaecfade7f5e117c98d7635b2aba95f">logUser</a>(<span class="stringliteral">&#39;workshop new&#39;</span>, $wid);</div>
<div class="line"><a name="l00528"></a><span class="lineno">  528</span>&#160;                <a class="code" href="index_8php.html#a6e8525da6dad002542958c13132118e4">callAction</a>(<span class="stringliteral">&#39;editWorkshop&#39;</span>, array($wid), <span class="keyword">true</span>);</div>
<div class="line"><a name="l00529"></a><span class="lineno">  529</span>&#160;        }</div>
<div class="line"><a name="l00530"></a><span class="lineno">  530</span>&#160;        <span class="keywordflow">else</span></div>
<div class="line"><a name="l00531"></a><span class="lineno">  531</span>&#160;        {</div>
<div class="line"><a name="l00532"></a><span class="lineno">  532</span>&#160;                $DB-&gt;workshops[$wid]-&gt;update($data);</div>
<div class="line"><a name="l00533"></a><span class="lineno">  533</span>&#160;                $DB-&gt;query(<span class="stringliteral">&#39;DELETE FROM table_workshop_subjects WHERE wid=$1&#39;</span>, $wid);</div>
<div class="line"><a name="l00534"></a><span class="lineno">  534</span>&#160;                <span class="keywordflow">if</span> (!empty($_POST[<span class="stringliteral">&#39;subjects&#39;</span>]))</div>
<div class="line"><a name="l00535"></a><span class="lineno">  535</span>&#160;                        <span class="keywordflow">foreach</span> ($_POST[<span class="stringliteral">&#39;subjects&#39;</span>] as $d)</div>
<div class="line"><a name="l00536"></a><span class="lineno">  536</span>&#160;                                $DB-&gt;workshop_subjects[]= array(<span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid, <span class="stringliteral">&#39;subject&#39;</span>=&gt;$d);</div>
<div class="line"><a name="l00537"></a><span class="lineno">  537</span>&#160;                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;Saved.&#39;</span>), <span class="stringliteral">&#39;success&#39;</span>);</div>
<div class="line"><a name="l00538"></a><span class="lineno">  538</span>&#160;                <a class="code" href="log_8php.html#a5eaecfade7f5e117c98d7635b2aba95f">logUser</a>(<span class="stringliteral">&#39;workshop edit&#39;</span>, $wid);</div>
<div class="line"><a name="l00539"></a><span class="lineno">  539</span>&#160;        }</div>
<div class="line"><a name="l00540"></a><span class="lineno">  540</span>&#160;}</div>
<div class="line"><a name="l00541"></a><span class="lineno">  541</span>&#160;</div>
<div class="line"><a name="l00542"></a><span class="lineno"><a class="code" href="workshop_8php.html#a38fddb96cb8474ef70b6c580aee4397f">  542</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a38fddb96cb8474ef70b6c580aee4397f">actionEditWorkshopLecturers</a>($wid)</div>
<div class="line"><a name="l00543"></a><span class="lineno">  543</span>&#160;{</div>
<div class="line"><a name="l00544"></a><span class="lineno">  544</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00545"></a><span class="lineno">  545</span>&#160;        $wid = intval($wid);</div>
<div class="line"><a name="l00546"></a><span class="lineno">  546</span>&#160;        $lecturers = <a class="code" href="workshop_8php.html#a02e8f38b818a3b8abd93a56b25d0ede6">getLecturers</a>($wid);</div>
<div class="line"><a name="l00547"></a><span class="lineno">  547</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;editWorkshop&#39;</span>, $lecturers))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00548"></a><span class="lineno">  548</span>&#160;</div>
<div class="line"><a name="l00549"></a><span class="lineno">  549</span>&#160;        $inputs = array();</div>
<div class="line"><a name="l00550"></a><span class="lineno">  550</span>&#160;        <span class="keywordflow">foreach</span> ($lecturers as $lecturer)</div>
<div class="line"><a name="l00551"></a><span class="lineno">  551</span>&#160;                $inputs[<span class="stringliteral">&#39;uid&#39;</span>. $lecturer]= array(</div>
<div class="line"><a name="l00552"></a><span class="lineno">  552</span>&#160;                        <span class="stringliteral">&#39;name&#39;</span> =&gt; <span class="stringliteral">&#39;uid&#39;</span>. $lecturer,</div>
<div class="line"><a name="l00553"></a><span class="lineno">  553</span>&#160;                        <span class="stringliteral">&#39;type&#39;</span> =&gt; <span class="stringliteral">&#39;custom&#39;</span>,</div>
<div class="line"><a name="l00554"></a><span class="lineno">  554</span>&#160;                        <span class="stringliteral">&#39;description&#39;</span> =&gt; <a class="code" href="user_2utils_8php.html#a29f037f468ee2716970ae6e7293644e2">getUserBadge</a>($lecturer, <span class="keyword">true</span>),</div>
<div class="line"><a name="l00555"></a><span class="lineno">  555</span>&#160;                        <span class="stringliteral">&#39;custom&#39;</span>=&gt;<span class="stringliteral">&quot;&lt;a href=&#39;removeWorkshopLecturer($wid;$lecturer)&#39;&gt;[&quot;</span>. _(<span class="stringliteral">&#39;remove&#39;</span>). <span class="stringliteral">&quot;]&lt;/a&gt;&quot;</span></div>
<div class="line"><a name="l00556"></a><span class="lineno">  556</span>&#160;                );</div>
<div class="line"><a name="l00557"></a><span class="lineno">  557</span>&#160;</div>
<div class="line"><a name="l00558"></a><span class="lineno">  558</span>&#160;        $inputs[<span class="stringliteral">&#39;lecturer&#39;</span>]= array(</div>
<div class="line"><a name="l00559"></a><span class="lineno">  559</span>&#160;                <span class="stringliteral">&#39;name&#39;</span>=&gt;<span class="stringliteral">&#39;lecturer&#39;</span>,</div>
<div class="line"><a name="l00560"></a><span class="lineno">  560</span>&#160;                <span class="stringliteral">&#39;type&#39;</span>=&gt;<span class="stringliteral">&#39;text&#39;</span>,</div>
<div class="line"><a name="l00561"></a><span class="lineno">  561</span>&#160;                <span class="stringliteral">&#39;description&#39;</span> =&gt; _(<span class="stringliteral">&#39;Full name or uid&#39;</span>)</div>
<div class="line"><a name="l00562"></a><span class="lineno">  562</span>&#160;        );</div>
<div class="line"><a name="l00563"></a><span class="lineno">  563</span>&#160;        $inputs[<span class="stringliteral">&#39;lecturer&#39;</span>][<span class="stringliteral">&#39;autocomplete&#39;</span>] = $DB-&gt;query(<span class="stringliteral">&#39;</span></div>
<div class="line"><a name="l00564"></a><span class="lineno">  564</span>&#160;<span class="stringliteral">                SELECT name FROM table_users u</span></div>
<div class="line"><a name="l00565"></a><span class="lineno">  565</span>&#160;<span class="stringliteral">                WHERE EXISTS (SELECT * FROM table_edition_users eu</span></div>
<div class="line"><a name="l00566"></a><span class="lineno">  566</span>&#160;<span class="stringliteral">                        WHERE eu.uid=u.uid AND eu.lecturer=1 AND eu.edition=$1)</span></div>
<div class="line"><a name="l00567"></a><span class="lineno">  567</span>&#160;<span class="stringliteral">                ORDER BY name&#39;</span>, <a class="code" href="utils_8php.html#a86acce3c002ca1af709fd1b04f2f82fa">getOption</a>(<span class="stringliteral">&#39;currentEdition&#39;</span>))-&gt;fetch_column();</div>
<div class="line"><a name="l00568"></a><span class="lineno">  568</span>&#160;</div>
<div class="line"><a name="l00569"></a><span class="lineno">  569</span>&#160;        $PAGE-&gt;title = _(<span class="stringliteral">&#39;Add/remove lecturers&#39;</span>);</div>
<div class="line"><a name="l00570"></a><span class="lineno">  570</span>&#160;        echo <span class="stringliteral">&quot;&lt;a class=&#39;back&#39; href=&#39;editWorkshop($wid)&#39;&gt;&quot;</span>. _(<span class="stringliteral">&#39;back&#39;</span>) .<span class="stringliteral">&quot;&lt;/a&gt;&quot;</span>;</div>
<div class="line"><a name="l00571"></a><span class="lineno">  571</span>&#160;        echo <span class="stringliteral">&#39;&lt;h3&gt;&#39;</span>. $DB-&gt;workshops($wid)-&gt;get(<span class="stringliteral">&#39;title&#39;</span>) .<span class="stringliteral">&#39;&lt;/h3&gt;&#39;</span>;</div>
<div class="line"><a name="l00572"></a><span class="lineno">  572</span>&#160;        $form = <span class="keyword">new</span> <a class="code" href="classForm.html">Form</a>($inputs);</div>
<div class="line"><a name="l00573"></a><span class="lineno">  573</span>&#160;        <span class="keywordflow">if</span> ($form-&gt;submitted())</div>
<div class="line"><a name="l00574"></a><span class="lineno">  574</span>&#160;        {</div>
<div class="line"><a name="l00575"></a><span class="lineno">  575</span>&#160;                $values = $form-&gt;fetchAndValidateValues();</div>
<div class="line"><a name="l00576"></a><span class="lineno">  576</span>&#160;                <span class="keywordflow">if</span> ($form-&gt;valid)</div>
<div class="line"><a name="l00577"></a><span class="lineno">  577</span>&#160;                        <a class="code" href="workshop_8php.html#a44e0748dce9adec0e6363a99f50507e0">actionAddWorkshopLecturer</a>($wid, $values[<span class="stringliteral">&#39;lecturer&#39;</span>]);</div>
<div class="line"><a name="l00578"></a><span class="lineno">  578</span>&#160;        }</div>
<div class="line"><a name="l00579"></a><span class="lineno">  579</span>&#160;        $form-&gt;submitValue = _(<span class="stringliteral">&#39;Add&#39;</span>);</div>
<div class="line"><a name="l00580"></a><span class="lineno">  580</span>&#160;        echo $form-&gt;getHTML();</div>
<div class="line"><a name="l00581"></a><span class="lineno">  581</span>&#160;}</div>
<div class="line"><a name="l00582"></a><span class="lineno">  582</span>&#160;</div>
<div class="line"><a name="l00583"></a><span class="lineno"><a class="code" href="workshop_8php.html#aa7552eb71810bd0d694aada5b3e040da">  583</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#aa7552eb71810bd0d694aada5b3e040da">actionRemoveWorkshopLecturer</a>($wid, $uid, $confirm = <span class="keyword">false</span>)</div>
<div class="line"><a name="l00584"></a><span class="lineno">  584</span>&#160;{</div>
<div class="line"><a name="l00585"></a><span class="lineno">  585</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00586"></a><span class="lineno">  586</span>&#160;        $wid = intval($wid);</div>
<div class="line"><a name="l00587"></a><span class="lineno">  587</span>&#160;        $uid = intval($uid);</div>
<div class="line"><a name="l00588"></a><span class="lineno">  588</span>&#160;        $lecturers = <a class="code" href="workshop_8php.html#a02e8f38b818a3b8abd93a56b25d0ede6">getLecturers</a>($wid);</div>
<div class="line"><a name="l00589"></a><span class="lineno">  589</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;editWorkshop&#39;</span>, $lecturers))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00590"></a><span class="lineno">  590</span>&#160;</div>
<div class="line"><a name="l00591"></a><span class="lineno">  591</span>&#160;        <span class="keywordflow">if</span> (!in_array($uid, $lecturers))</div>
<div class="line"><a name="l00592"></a><span class="lineno">  592</span>&#160;                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;The user is not a lecturer.&#39;</span>), <span class="stringliteral">&#39;userError&#39;</span>);</div>
<div class="line"><a name="l00593"></a><span class="lineno">  593</span>&#160;        <span class="keywordflow">else</span> <span class="keywordflow">if</span> (($uid == $USER[<span class="stringliteral">&#39;uid&#39;</span>]) &amp;&amp; !$confirm)</div>
<div class="line"><a name="l00594"></a><span class="lineno">  594</span>&#160;        {</div>
<div class="line"><a name="l00595"></a><span class="lineno">  595</span>&#160;                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;Are you sure you want to remove yourself from lecturers?&#39;</span>) .<span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>.</div>
<div class="line"><a name="l00596"></a><span class="lineno">  596</span>&#160;                        <span class="stringliteral">&quot;&lt;a href=&#39;removeWorkshopLecturer($wid;$uid;1)&#39; class=&#39;button&#39;&gt;&quot;</span>. _(<span class="stringliteral">&#39;yes&#39;</span>). <span class="stringliteral">&quot;&lt;/a&gt; &quot;</span>.</div>
<div class="line"><a name="l00597"></a><span class="lineno">  597</span>&#160;                        <span class="stringliteral">&quot;&lt;a href=&#39;editWorkshopLecturers($wid)&#39; class=&#39;button&#39;&gt;&quot;</span>. _(<span class="stringliteral">&#39;cancel&#39;</span>). <span class="stringliteral">&quot;&lt;/a&gt;&quot;</span>,</div>
<div class="line"><a name="l00598"></a><span class="lineno">  598</span>&#160;                        <span class="stringliteral">&#39;warning&#39;</span>);</div>
<div class="line"><a name="l00599"></a><span class="lineno">  599</span>&#160;        }</div>
<div class="line"><a name="l00600"></a><span class="lineno">  600</span>&#160;        <span class="keywordflow">else</span></div>
<div class="line"><a name="l00601"></a><span class="lineno">  601</span>&#160;        {</div>
<div class="line"><a name="l00602"></a><span class="lineno">  602</span>&#160;                $DB-&gt;query(<span class="stringliteral">&#39;DELETE FROM table_workshop_users WHERE wid=$1 AND uid=$2&#39;</span>, $wid, $uid);</div>
<div class="line"><a name="l00603"></a><span class="lineno">  603</span>&#160;                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;The user has been removed from lecturers here.&#39;</span>), <span class="stringliteral">&#39;success&#39;</span>);</div>
<div class="line"><a name="l00604"></a><span class="lineno">  604</span>&#160;                <span class="keywordflow">if</span> ($uid == $USER[<span class="stringliteral">&#39;uid&#39;</span>])</div>
<div class="line"><a name="l00605"></a><span class="lineno">  605</span>&#160;                        <a class="code" href="index_8php.html#a6e8525da6dad002542958c13132118e4">callAction</a>(<span class="stringliteral">&#39;listOwnWorkshops&#39;</span>, null, <span class="keyword">true</span>);</div>
<div class="line"><a name="l00606"></a><span class="lineno">  606</span>&#160;        }</div>
<div class="line"><a name="l00607"></a><span class="lineno">  607</span>&#160;        <a class="code" href="index_8php.html#a6e8525da6dad002542958c13132118e4">callAction</a>(<span class="stringliteral">&#39;editWorkshopLecturers&#39;</span>, array($wid));</div>
<div class="line"><a name="l00608"></a><span class="lineno">  608</span>&#160;}</div>
<div class="line"><a name="l00609"></a><span class="lineno">  609</span>&#160;</div>
<div class="line"><a name="l00610"></a><span class="lineno"><a class="code" href="workshop_8php.html#a44e0748dce9adec0e6363a99f50507e0">  610</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a44e0748dce9adec0e6363a99f50507e0">actionAddWorkshopLecturer</a>($wid, $lecturer, $confirm = <span class="keyword">false</span>)</div>
<div class="line"><a name="l00611"></a><span class="lineno">  611</span>&#160;{</div>
<div class="line"><a name="l00612"></a><span class="lineno">  612</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00613"></a><span class="lineno">  613</span>&#160;        $lecturers = <a class="code" href="workshop_8php.html#a02e8f38b818a3b8abd93a56b25d0ede6">getLecturers</a>($wid);</div>
<div class="line"><a name="l00614"></a><span class="lineno">  614</span>&#160;</div>
<div class="line"><a name="l00615"></a><span class="lineno">  615</span>&#160;        <span class="comment">/* Convert textual $lecturer to $uid (a long and boring part). */</span></div>
<div class="line"><a name="l00616"></a><span class="lineno">  616</span>&#160;        <span class="keywordflow">if</span> (is_numeric($lecturer))</div>
<div class="line"><a name="l00617"></a><span class="lineno">  617</span>&#160;        {</div>
<div class="line"><a name="l00618"></a><span class="lineno">  618</span>&#160;                $uid = intval($lecturer);</div>
<div class="line"><a name="l00619"></a><span class="lineno">  619</span>&#160;                <span class="keywordflow">if</span> (!isset($DB-&gt;users[$uid]))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classKnownException.html">KnownException</a>(_(<span class="stringliteral">&#39;User not found.&#39;</span>));</div>
<div class="line"><a name="l00620"></a><span class="lineno">  620</span>&#160;        }</div>
<div class="line"><a name="l00621"></a><span class="lineno">  621</span>&#160;        <span class="keywordflow">else</span></div>
<div class="line"><a name="l00622"></a><span class="lineno">  622</span>&#160;        {</div>
<div class="line"><a name="l00623"></a><span class="lineno">  623</span>&#160;                <span class="comment">// Try to match the name.</span></div>
<div class="line"><a name="l00624"></a><span class="lineno">  624</span>&#160;                $uid = $DB-&gt;query(<span class="stringliteral">&#39;SELECT uid FROM table_users WHERE name=$1&#39;</span>, trim($lecturer))-&gt;fetch();</div>
<div class="line"><a name="l00625"></a><span class="lineno">  625</span>&#160;                <span class="keywordflow">if</span> ($uid === null)</div>
<div class="line"><a name="l00626"></a><span class="lineno">  626</span>&#160;                {</div>
<div class="line"><a name="l00627"></a><span class="lineno">  627</span>&#160;                        <span class="comment">// Fuzzy match - find name with least levenshtein distance.</span></div>
<div class="line"><a name="l00628"></a><span class="lineno">  628</span>&#160;                        $names = $DB-&gt;query(<span class="stringliteral">&#39;</span></div>
<div class="line"><a name="l00629"></a><span class="lineno">  629</span>&#160;<span class="stringliteral">                                SELECT uid, name FROM table_users u</span></div>
<div class="line"><a name="l00630"></a><span class="lineno">  630</span>&#160;<span class="stringliteral">                                WHERE EXISTS (SELECT * FROM table_edition_users eu</span></div>
<div class="line"><a name="l00631"></a><span class="lineno">  631</span>&#160;<span class="stringliteral">                                        WHERE eu.uid=u.uid AND eu.lecturer=1 AND eu.edition=$1)</span></div>
<div class="line"><a name="l00632"></a><span class="lineno">  632</span>&#160;<span class="stringliteral">                                ORDER BY name&#39;</span>, <a class="code" href="utils_8php.html#a86acce3c002ca1af709fd1b04f2f82fa">getOption</a>(<span class="stringliteral">&#39;currentEdition&#39;</span>))-&gt;fetch_all();</div>
<div class="line"><a name="l00633"></a><span class="lineno">  633</span>&#160;                        $best = 100000;</div>
<div class="line"><a name="l00634"></a><span class="lineno">  634</span>&#160;                        $bestname = <span class="stringliteral">&#39;&#39;</span>;</div>
<div class="line"><a name="l00635"></a><span class="lineno">  635</span>&#160;                        <span class="keywordflow">foreach</span> ($names as $name)</div>
<div class="line"><a name="l00636"></a><span class="lineno">  636</span>&#160;                                <span class="keywordflow">if</span> (levenshtein($name[<span class="stringliteral">&#39;name&#39;</span>], $lecturer) &lt; $best)</div>
<div class="line"><a name="l00637"></a><span class="lineno">  637</span>&#160;                                {</div>
<div class="line"><a name="l00638"></a><span class="lineno">  638</span>&#160;                                        $best = levenshtein($name[<span class="stringliteral">&#39;name&#39;</span>], $lecturer);</div>
<div class="line"><a name="l00639"></a><span class="lineno">  639</span>&#160;                                        $uid = $name[<span class="stringliteral">&#39;uid&#39;</span>];</div>
<div class="line"><a name="l00640"></a><span class="lineno">  640</span>&#160;                                        $bestname = $name[<span class="stringliteral">&#39;name&#39;</span>];</div>
<div class="line"><a name="l00641"></a><span class="lineno">  641</span>&#160;                                }</div>
<div class="line"><a name="l00642"></a><span class="lineno">  642</span>&#160;                        $PAGE-&gt;addMessage(sprintf(_(<span class="stringliteral">&#39;Fuzzy-matched user #%d&#39;</span>), $uid) .<span class="stringliteral">&quot; &lt;i&gt;$bestname&lt;/i&gt;&quot;</span>, <span class="stringliteral">&#39;info&#39;</span>);</div>
<div class="line"><a name="l00643"></a><span class="lineno">  643</span>&#160;                }</div>
<div class="line"><a name="l00644"></a><span class="lineno">  644</span>&#160;        }</div>
<div class="line"><a name="l00645"></a><span class="lineno">  645</span>&#160;</div>
<div class="line"><a name="l00646"></a><span class="lineno">  646</span>&#160;        <span class="keywordflow">if</span> (in_array($uid, $lecturers))</div>
<div class="line"><a name="l00647"></a><span class="lineno">  647</span>&#160;                $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;The user you selected already is a lecturer here.&#39;</span>), <span class="stringliteral">&#39;userError&#39;</span>);</div>
<div class="line"><a name="l00648"></a><span class="lineno">  648</span>&#160;        <span class="keywordflow">else</span></div>
<div class="line"><a name="l00649"></a><span class="lineno">  649</span>&#160;        {</div>
<div class="line"><a name="l00650"></a><span class="lineno">  650</span>&#160;                $DB-&gt;query(<span class="stringliteral">&#39;SELECT count(*) FROM table_workshop_users WHERE wid=$1 AND uid=$2&#39;</span>, $wid, $uid);</div>
<div class="line"><a name="l00651"></a><span class="lineno">  651</span>&#160;                <span class="keywordflow">if</span> ($DB-&gt;fetch() &amp;&amp; ($confirm === <span class="keyword">false</span>))</div>
<div class="line"><a name="l00652"></a><span class="lineno">  652</span>&#160;                {</div>
<div class="line"><a name="l00653"></a><span class="lineno">  653</span>&#160;                        $PAGE-&gt;addMessage(</div>
<div class="line"><a name="l00654"></a><span class="lineno">  654</span>&#160;                                _(<span class="stringliteral">&#39;The user already signed up as a participant. Sign him out and add to lecturers?&#39;</span>) .</div>
<div class="line"><a name="l00655"></a><span class="lineno">  655</span>&#160;                                <span class="stringliteral">&#39;&lt;br/&gt;&#39;</span>.</div>
<div class="line"><a name="l00656"></a><span class="lineno">  656</span>&#160;                                <span class="stringliteral">&quot;&lt;a href=&#39;addWorkshopLecturer($wid;$uid;1)&#39; class=&#39;button&#39;&gt;&quot;</span>. _(<span class="stringliteral">&#39;yes&#39;</span>) .<span class="stringliteral">&quot;&lt;/a&gt; &quot;</span>.</div>
<div class="line"><a name="l00657"></a><span class="lineno">  657</span>&#160;                                <span class="stringliteral">&quot;&lt;a href=&#39;editWorkshopLecturers($wid)&#39; class=&#39;button&#39;&gt;&quot;</span>. _(<span class="stringliteral">&#39;cancel&#39;</span>). <span class="stringliteral">&quot;&lt;/a&gt;&quot;</span>,</div>
<div class="line"><a name="l00658"></a><span class="lineno">  658</span>&#160;                                <span class="stringliteral">&#39;warning&#39;</span>);</div>
<div class="line"><a name="l00659"></a><span class="lineno">  659</span>&#160;                }</div>
<div class="line"><a name="l00660"></a><span class="lineno">  660</span>&#160;                <span class="keywordflow">else</span></div>
<div class="line"><a name="l00661"></a><span class="lineno">  661</span>&#160;                {</div>
<div class="line"><a name="l00662"></a><span class="lineno">  662</span>&#160;                        <span class="keywordflow">if</span> ($confirm !== <span class="keyword">false</span>)</div>
<div class="line"><a name="l00663"></a><span class="lineno">  663</span>&#160;                                $DB-&gt;query(<span class="stringliteral">&#39;DELETE FROM table_workshop_users WHERE wid=$1 AND uid=$2&#39;</span>, $wid, $uid);</div>
<div class="line"><a name="l00664"></a><span class="lineno">  664</span>&#160;                        $DB-&gt;workshop_users[]= array(<span class="stringliteral">&#39;uid&#39;</span>=&gt;$uid, <span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid,</div>
<div class="line"><a name="l00665"></a><span class="lineno">  665</span>&#160;                                <span class="stringliteral">&#39;participant&#39;</span>=&gt;<a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>(<span class="stringliteral">&#39;lecturer&#39;</span>)-&gt;<span class="keywordtype">id</span>);</div>
<div class="line"><a name="l00666"></a><span class="lineno">  666</span>&#160;                        $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;Added user to lecturers.&#39;</span>), <span class="stringliteral">&#39;success&#39;</span>);</div>
<div class="line"><a name="l00667"></a><span class="lineno">  667</span>&#160;                }</div>
<div class="line"><a name="l00668"></a><span class="lineno">  668</span>&#160;        }</div>
<div class="line"><a name="l00669"></a><span class="lineno">  669</span>&#160;</div>
<div class="line"><a name="l00670"></a><span class="lineno">  670</span>&#160;        <a class="code" href="index_8php.html#a6e8525da6dad002542958c13132118e4">callAction</a>(<span class="stringliteral">&#39;editWorkshopLecturers&#39;</span>, array($wid));</div>
<div class="line"><a name="l00671"></a><span class="lineno">  671</span>&#160;}</div>
<div class="line"><a name="l00672"></a><span class="lineno">  672</span>&#160;</div>
<div class="line"><a name="l00673"></a><span class="lineno">  673</span>&#160;</div>
<div class="line"><a name="l00674"></a><span class="lineno"><a class="code" href="workshop_8php.html#a538a5114f43f9e0ff781829a2ec568b0">  674</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a538a5114f43f9e0ff781829a2ec568b0">actionSignUpForWorkshop</a>($wid)</div>
<div class="line"><a name="l00675"></a><span class="lineno">  675</span>&#160;{</div>
<div class="line"><a name="l00676"></a><span class="lineno">  676</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00677"></a><span class="lineno">  677</span>&#160;        $wid = intval($wid);</div>
<div class="line"><a name="l00678"></a><span class="lineno">  678</span>&#160;        <span class="keywordflow">if</span> (!<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;signUpForWorkshop&#39;</span>))  <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classPolicyException.html">PolicyException</a>();</div>
<div class="line"><a name="l00679"></a><span class="lineno">  679</span>&#160;</div>
<div class="line"><a name="l00680"></a><span class="lineno">  680</span>&#160;        $participant = <span class="stringliteral">&#39;candidate&#39;</span>;</div>
<div class="line"><a name="l00681"></a><span class="lineno">  681</span>&#160;        <span class="keywordflow">if</span> (<a class="code" href="user_2utils_8php.html#a1e9c8ed2c5ed2def1a367c9ffd04114b">userCan</a>(<span class="stringliteral">&#39;autoQualifyForWorkshop&#39;</span>))  $participant = <span class="stringliteral">&#39;autoaccepted&#39;</span>;</div>
<div class="line"><a name="l00682"></a><span class="lineno">  682</span>&#160;        $participant = <a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>($participant)-&gt;id;</div>
<div class="line"><a name="l00683"></a><span class="lineno">  683</span>&#160;</div>
<div class="line"><a name="l00684"></a><span class="lineno">  684</span>&#160;        $dbRow = $DB-&gt;workshop_users[array(<span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid,<span class="stringliteral">&#39;uid&#39;</span>=&gt;$USER[<span class="stringliteral">&#39;uid&#39;</span>])];</div>
<div class="line"><a name="l00685"></a><span class="lineno">  685</span>&#160;        <span class="keywordflow">if</span> (!$dbRow-&gt;count())</div>
<div class="line"><a name="l00686"></a><span class="lineno">  686</span>&#160;                $DB-&gt;workshop_users[] = array(<span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid,<span class="stringliteral">&#39;uid&#39;</span>=&gt;$USER[<span class="stringliteral">&#39;uid&#39;</span>], <span class="stringliteral">&#39;participant&#39;</span>=&gt;$participant);</div>
<div class="line"><a name="l00687"></a><span class="lineno">  687</span>&#160;        <span class="keywordflow">else</span></div>
<div class="line"><a name="l00688"></a><span class="lineno">  688</span>&#160;        {</div>
<div class="line"><a name="l00689"></a><span class="lineno">  689</span>&#160;                <span class="keywordflow">if</span> ($dbRow-&gt;get(<span class="stringliteral">&#39;participant&#39;</span>) != <a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>(<span class="stringliteral">&#39;none&#39;</span>)-&gt;id)</div>
<div class="line"><a name="l00690"></a><span class="lineno">  690</span>&#160;                        <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classKnownException.html">KnownException</a>(_(<span class="stringliteral">&#39;You\&#39;re already signed up for this workshop block.&#39;</span>));</div>
<div class="line"><a name="l00691"></a><span class="lineno">  691</span>&#160;                $dbRow-&gt;update(array(<span class="stringliteral">&#39;participant&#39;</span>=&gt;$participant));</div>
<div class="line"><a name="l00692"></a><span class="lineno">  692</span>&#160;        }</div>
<div class="line"><a name="l00693"></a><span class="lineno">  693</span>&#160;</div>
<div class="line"><a name="l00694"></a><span class="lineno">  694</span>&#160;        $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;Signed up for a workshop block.&#39;</span>), <span class="stringliteral">&#39;success&#39;</span>);</div>
<div class="line"><a name="l00695"></a><span class="lineno">  695</span>&#160;        <a class="code" href="index_8php.html#a6e8525da6dad002542958c13132118e4">callAction</a>(<span class="stringliteral">&#39;showWorkshop&#39;</span>, array($wid));</div>
<div class="line"><a name="l00696"></a><span class="lineno">  696</span>&#160;        <a class="code" href="log_8php.html#a5eaecfade7f5e117c98d7635b2aba95f">logUser</a>(<span class="stringliteral">&#39;workshop participant signup&#39;</span>, $wid);</div>
<div class="line"><a name="l00697"></a><span class="lineno">  697</span>&#160;}</div>
<div class="line"><a name="l00698"></a><span class="lineno">  698</span>&#160;</div>
<div class="line"><a name="l00699"></a><span class="lineno"><a class="code" href="workshop_8php.html#a5a0d9cba96e5c17779acedf8d471605a">  699</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a5a0d9cba96e5c17779acedf8d471605a">actionResignFromWorkshop</a>($wid)</div>
<div class="line"><a name="l00700"></a><span class="lineno">  700</span>&#160;{</div>
<div class="line"><a name="l00701"></a><span class="lineno">  701</span>&#160;        global $USER, <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>, <a class="code" href="index_8php.html#ae1848ae8dc4014bc7c680e5504a8eef0">$PAGE</a>;</div>
<div class="line"><a name="l00702"></a><span class="lineno">  702</span>&#160;        $wid = intval($wid);</div>
<div class="line"><a name="l00703"></a><span class="lineno">  703</span>&#160;        $dbRow = $DB-&gt;workshop_users[array(<span class="stringliteral">&#39;wid&#39;</span>=&gt;$wid,<span class="stringliteral">&#39;uid&#39;</span>=&gt;$USER[<span class="stringliteral">&#39;uid&#39;</span>])];</div>
<div class="line"><a name="l00704"></a><span class="lineno">  704</span>&#160;        $participant = <a class="code" href="enum_8php.html#af4fcf7a20cf66ed8f77cae36bc444b83">enumParticipantStatus</a>(intval($dbRow-&gt;get(<span class="stringliteral">&#39;participant&#39;</span>)));</div>
<div class="line"><a name="l00705"></a><span class="lineno">  705</span>&#160;        <span class="keywordflow">if</span> (!$participant-&gt;canResign)</div>
<div class="line"><a name="l00706"></a><span class="lineno">  706</span>&#160;                <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classKnownException.html">KnownException</a>(_(<span class="stringliteral">&#39;Your can\&#39;t resign from your status: &#39;</span>). $participant-&gt;description);</div>
<div class="line"><a name="l00707"></a><span class="lineno">  707</span>&#160;        $dbRow-&gt;delete();</div>
<div class="line"><a name="l00708"></a><span class="lineno">  708</span>&#160;        $PAGE-&gt;addMessage(_(<span class="stringliteral">&#39;Resigned from workshop block.&#39;</span>), <span class="stringliteral">&#39;success&#39;</span>);</div>
<div class="line"><a name="l00709"></a><span class="lineno">  709</span>&#160;        <a class="code" href="index_8php.html#a6e8525da6dad002542958c13132118e4">callAction</a>(<span class="stringliteral">&#39;showWorkshop&#39;</span>, array($wid));</div>
<div class="line"><a name="l00710"></a><span class="lineno">  710</span>&#160;        <a class="code" href="log_8php.html#a5eaecfade7f5e117c98d7635b2aba95f">logUser</a>(<span class="stringliteral">&#39;workshop participant resign&#39;</span>, $wid);</div>
<div class="line"><a name="l00711"></a><span class="lineno">  711</span>&#160;}</div>
<div class="line"><a name="l00712"></a><span class="lineno">  712</span>&#160;</div>
<div class="line"><a name="l00713"></a><span class="lineno"><a class="code" href="workshop_8php.html#ae8c3b8a730d8fb94ef2ca3af1e8582a4">  713</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#ae8c3b8a730d8fb94ef2ca3af1e8582a4">subjectOrder</a>($subjects)</div>
<div class="line"><a name="l00714"></a><span class="lineno">  714</span>&#160;{</div>
<div class="line"><a name="l00715"></a><span class="lineno">  715</span>&#160;        $r = 0;</div>
<div class="line"><a name="l00716"></a><span class="lineno">  716</span>&#160;        <span class="keywordflow">foreach</span> (<a class="code" href="enum_8php.html#a77f5eebe56acc69d13486423d13cb83d">enumSubject</a>() as $subjectName=&gt;$subject)</div>
<div class="line"><a name="l00717"></a><span class="lineno">  717</span>&#160;                <span class="keywordflow">if</span> (in_array($subjectName, $subjects))</div>
<div class="line"><a name="l00718"></a><span class="lineno">  718</span>&#160;                        $r += $subject-&gt;orderWeight;</div>
<div class="line"><a name="l00719"></a><span class="lineno">  719</span>&#160;        <span class="keywordflow">return</span> $r;</div>
<div class="line"><a name="l00720"></a><span class="lineno">  720</span>&#160;}</div>
<div class="line"><a name="l00721"></a><span class="lineno">  721</span>&#160;</div>
<div class="line"><a name="l00722"></a><span class="lineno"><a class="code" href="workshop_8php.html#a94f343d568c722874d829e163cf0a361">  722</a></span>&#160;<span class="keyword">function</span> <a class="code" href="workshop_8php.html#a94f343d568c722874d829e163cf0a361">actionRecountSubjectOrder</a>()</div>
<div class="line"><a name="l00723"></a><span class="lineno">  723</span>&#160;{</div>
<div class="line"><a name="l00724"></a><span class="lineno">  724</span>&#160;        global <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>;</div>
<div class="line"><a name="l00725"></a><span class="lineno">  725</span>&#160;        $wids = $DB-&gt;query(<span class="stringliteral">&#39;SELECT wid FROM table_workshops&#39;</span>)-&gt;fetch_column();</div>
<div class="line"><a name="l00726"></a><span class="lineno">  726</span>&#160;        <span class="keywordflow">foreach</span> ($wids as $wid)</div>
<div class="line"><a name="l00727"></a><span class="lineno">  727</span>&#160;        {</div>
<div class="line"><a name="l00728"></a><span class="lineno">  728</span>&#160;                $DB-&gt;query(<span class="stringliteral">&#39;SELECT subject FROM table_workshop_subjects WHERE wid=$1&#39;</span>, $wid);</div>
<div class="line"><a name="l00729"></a><span class="lineno">  729</span>&#160;                $order = <a class="code" href="workshop_8php.html#ae8c3b8a730d8fb94ef2ca3af1e8582a4">subjectOrder</a>($DB-&gt;fetch_column());</div>
<div class="line"><a name="l00730"></a><span class="lineno">  730</span>&#160;                $DB-&gt;workshops[$wid]-&gt;update(array(<span class="stringliteral">&#39;subjects_order&#39;</span>=&gt;$order));</div>
<div class="line"><a name="l00731"></a><span class="lineno">  731</span>&#160;        }</div>
<div class="line"><a name="l00732"></a><span class="lineno">  732</span>&#160;}</div>
</div><!-- fragment --></div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated on Sun Sep 8 2013 17:44:57 for wwwApp by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.1.1
</small></address>
</body>
</html>
